Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Capturing a return value from an Oracle Function?
Message
From
15/09/1999 14:35:26
 
 
To
15/09/1999 12:53:24
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00265064
Message ID:
00265127
Views:
20
OK, this may be way offbase and I have no way of testing it, but won't this create an SQLRESULT cursor with the value in an EXPR (could have the name wrong) field? Kinda like what @@IDENTITY does?

>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?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform