VB & Database, executing a stored procedure in oracle using ADO

executing a stored procedure in oracle using ADO

Author	Message
arunamuruges #1 / 5	executing a stored procedure in oracle using ADO My head is so meesed up this afternoon. Can someone give me a code snippet or tell me the syntax to execute a stored procedure in oracle. I have a stored proc. that takes in a parameter. ex. the stored proc. IS: CREATE OR REPLACE STORED PROCEDURE JOBS(V_JOB VARCHAR(20) IN) AS SELECT ENAME, HIREDATE FROM EMP WHERE JOB = V_JOB / So, well i need to pass a parameter through Visual Basic to this stored proc and get a record set out. There can be several records that match this parameter. Can please someone help me on this.... please please...... Thanks in advance and thanx a million. aruna
Tue, 18 Feb 2003 06:22:40 GMT

Carl Prothma #2 / 5	executing a stored procedure in oracle using ADO Aruna, Take a look at the following MS KB article: http://support.microsoft.com/support/kb/articles/q176/0/86.asp -- Thanks, Carl Prothman Microsoft Visual Basic MVP http://www.able-consulting.com Quote: > My head is so meesed up this afternoon. Can someone give me a code > snippet or tell me the syntax to execute a stored procedure in oracle. > I have a stored proc. that takes in a parameter. ex. the stored proc. > IS: > CREATE OR REPLACE STORED PROCEDURE JOBS(V_JOB VARCHAR(20) IN) AS > SELECT ENAME, HIREDATE FROM EMP WHERE JOB = V_JOB > / > So, well i need to pass a parameter through Visual Basic to this stored > proc and get a record set out. There can be several records that match > this parameter. > Can please someone help me on this.... please please...... > Thanks in advance and thanx a million. > aruna
Wed, 19 Feb 2003 02:08:22 GMT

arunamuruges #3 / 5	executing a stored procedure in oracle using ADO Carl, I did look at it.... butit says the recordsets are static and read only.... .any way to get around this. Plus, the article says i have to create packages in oracle .... is this true? Why can't i jsut execute a stored proc instead? Any ideas on this. Thanks, aruna * Sent from Devdex.com http://www.devdex.com The Web Developers Index * The world's largest index site for web developers.
Thu, 20 Feb 2003 02:29:31 GMT

Carl Prothma #4 / 5	executing a stored procedure in oracle using ADO Quote: > Carl, > I did look at it.... but it says the recordsets are static and read only.... .any way to get around this. A client side recordset is always static. If you want it to be updateable, then make sure to set the LockType to something other than ReadOnly. Also, the recordset may be read-only because of the type of SQL statement being used (e.g. joins) Quote: > Plus, the article says I have to create packages in oracle .... is this true? Why can't I just execute a stored proc instead? Any ideas on this. Not sure, I mainly use SQL Server. I do know that Oracle packages do work. -- Thanks, Carl Prothman Microsoft Visual Basic MVP http://www.able-consulting.com
Thu, 20 Feb 2003 03:14:41 GMT

jason_ha.. #5 / 5	executing a stored procedure in oracle using ADO Currently only Oracle's "Oracle Provider for OLE DB" can return a reference cursor parameter into an ADO recordset and the Oracle driver for ODBC can return a recordset using Oracle's PL/SQL tables. Check out http://www.digitaltier.com/knowledge/ for a detailed discussion on how to retrieve an ADO Recordset using Oracle stored procedures and PL/SQL table. JH Quote: > Aruna, > Take a look at the following MS KB article: > http://support.microsoft.com/support/kb/articles/q176/0/86.asp > -- > Thanks, > Carl Prothman > Microsoft Visual Basic MVP > http://www.able-consulting.com ... Quote: > > My head is so meesed up this afternoon. Can someone give me a code > > snippet or tell me the syntax to execute a stored procedure in oracle. > > I have a stored proc. that takes in a parameter. ex. the stored proc. > > IS: > > CREATE OR REPLACE STORED PROCEDURE JOBS(V_JOB VARCHAR(20) IN) AS > > SELECT ENAME, HIREDATE FROM EMP WHERE JOB = V_JOB > > / > > So, well i need to pass a parameter through Visual Basic to this stored > > proc and get a record set out. There can be several records that match > > this parameter. > > Can please someone help me on this.... please please...... > > Thanks in advance and thanx a million. > > aruna Sent via Deja.com http://www.deja.com/ Before you buy.
Sun, 09 Mar 2003 03:00:00 GMT

Page 1 of 1

[ 5 post ]