Re: executing Oracle SP using VB5 with RDO

From: Xiang Gao <cgao_at_sprint.ca>
Date: 2000/05/15
Message-ID: <GAUT4.37525$wz3.113144@newscontent-01.sprint.ca>#1/1

Hope the following example code will be helpful: (the stored procedure here is emp_insert with five IN parameters)

dim qyEmpInsert as rdoQuery
dim strSQL as string

strSQL="{call emp_insert(?,?,?,?,?)}"
set qyEmpInsert = cn.CreateQuery(" ", strSQL) /* cn is the rdoConnection */

'Provide the value to the parameters

qyEmpInsert(0) = 1234
qyEmpInsert(1) = 'Me'
qyEmpInsert(2) ='Clerk'
qyEmpInsert(3) = 2345
qyEmpInsert(4) = '12-may-1998'

qyEmpInsert.Execute

Good luck!

Seshan, Venkatesh (MLCC - FL) wrote in message <028c298c.f487b358_at_usw-ex0102-014.remarq.com>...
>I am trying to execute an oracle stored procedure
>using VB5 with RDO connection and I am getting "ORA-00900
>Invalid SQL statement."
>
>Can anyone please send me a sample VB5 code to execute a
>oracle stored procedure thru RDO connection.
>
>
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
>The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Mon May 15 2000 - 00:00:00 CDT