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