Certainly a strange one for me...
I am getting an Undefined Error from Provider; when I attempt to execute an Oracle Stored Procedure in vb script and run from DOS via cscript. This code works for other SPs I execute via VBS.
I confirmed I can run Proc in Oracle SQL*Developer, TOAD and SQL*Plus.
-- > EXEC MYSCHEMA.MY_SP_NAME_HERE
Any hints are appreciated. tia, Steve
Steve Medvid
IT Consultant & Web Master
I am getting an Undefined Error from Provider; when I attempt to execute an Oracle Stored Procedure in vb script and run from DOS via cscript. This code works for other SPs I execute via VBS.
I confirmed I can run Proc in Oracle SQL*Developer, TOAD and SQL*Plus.
-- > EXEC MYSCHEMA.MY_SP_NAME_HERE
Any hints are appreciated. tia, Steve
Code:
Set conn = CreateObject("ADODB.Connection")
conn.Open strConn
Set Cmd = CreateObject("ADODB.Command")
With Cmd
.ActiveConnection = conn
.CommandType = 1 ' 1 is text 4 is stored procedure 'Requires the adovbs.inc file or typelib meta tag
.CommandText = "{ call MYSCHEMA.MY_SP_NAME_HERE() }"
.CommandTimeout = 99999
End With
cmd.Execute
Steve Medvid
IT Consultant & Web Master