| cannot call a stored procedure using output parameters from OO4O [message #101046] |
Thu, 01 April 2004 16:27 |
seberg
Messages: 1
Registered: April 2004
|
Junior Member |
|
|
Hi all,
It is very urgent.Any help would be appreciated..
I'd like to call a stored procedure using output parameters from OO4O.
And I am doing like below, but it doesn't call.
Could you please help how I can make it?
-----------------------------------------------------------------
Dim OraSQLStmt As Object
Dim OrderDynaset As Object
OraDatabase.Parameters.Add "pn_Ret", 0, ORAPARM_OUTPUT
OraDatabase.Parameters("pn_Ret").ServerType = ORATYPE_CURSOR
Set OraSQLStmt = OraDatabase.ExecuteSQL("begin :pn_Ret :=TEST1(:pn_Ret); end;")
Set OrderDynaset = OraDatabase.Parameters("pn_Ret").Value
-----------------------------------------------------------------
TEST1 : name of stored procedure
pn_Ret : name of output parameter
I'm using Windows2000, Visual Basic 6.0, and Oracle 9i
Thanks
Best regards:
Seberg
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
