Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Capturing a return value from an Oracle Function?
Message
De
15/09/1999 14:35:26
 
 
À
15/09/1999 12:53:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00265064
Message ID:
00265127
Vues:
19
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform