Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Returning parameters from an Oracle Procedure (ado & vb6).

1 view
Skip to first unread message

dnaum...@gmail.com

unread,
Nov 29, 2006, 9:52:32 AM11/29/06
to
Hello,

I have an Oracle procedure defined as (this works in SQLPlus):
procedure fleet_prc( incriteria IN varchar2,
eng OUT varchar2,
engdt OUT varchar2,
trn OUT varchar2,
trndt OUT varchar2)

I've tried to access it via
Set cmdStoredProc = New ADODB.Command
Set cmdStoredProc.ActiveConnection = cnnOracle
cmdStoredProc.CommandType = adCmdText
strCommandText = "{call prc.fleet_prc(?,?,?,?,?)}"

cmdStoredProc.CommandText = strCommandText
cmdStoredProc.Parameters.Append
cmdStoredProc.CreateParameter("incriteria", adVarChar, adParamInput,
17, strVIN)
cmdStoredProc.Parameters.Append
cmdStoredProc.CreateParameter("eng", adVarChar, adParamOutput, 255)
cmdStoredProc.Parameters.Append
cmdStoredProc.CreateParameter("engdt", adVarChar, adParamOutput, 255)
cmdStoredProc.Parameters.Append
cmdStoredProc.CreateParameter("trn", adVarChar, adParamOutput, 255)
cmdStoredProc.Parameters.Append
cmdStoredProc.CreateParameter("trndt", adVarChar, adParamOutput, 255)

Set rsEmp = New ADODB.Recordset
Set rsEmp = cmdStoredProc.Execute()

However, at this point I receive the error:
[Microsoft][ODBC driver for Oracle]Syntax error or access

my connection string is:
Provider=MSDASQL.1;Extended
Properties="DRIVER={Microsoft ODBC for
Oracle};UID=****;PWD=***;SERVER=***;"

Any and all help would be appreciated!!!!

Thanks,

David

0 new messages