General information
Title:
Capturing a return value from an Oracle Function?
I am using SQL passthru that needs to make a call to an
Oracle function. The Oracle function will return a value (number
let's say 15).
So I need to make the SQL passthru do something like
this:
lnOk = SQLEXEC(gnhandle,"{call OracleFunction()}")
The problem is that lnOk contains the result of the
SQLEXEC. That is -1 if a problem, 0 is running and
1 if it was successful. I need the 15 or whatever
it is on the next call instead of the -1, 0 or 1.
Can I capture the value of '15' from the Oracle function?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only