>>Hi
>>
>>I need to execute a stored procedure on a 7.3.3 Oracle server.
>>
>>The stored procedure has both in and out parameters.
>>
>>This is an example of one of the sp's we need to execute:
>>
>>client_retrieve_funds_s(card_number,return_code)
>>
>>We have the connection and all works well doing things like:
>>
>>sqlexec(gconnect,"select * from table")
>>
>>But I could really use some help on this one.
>>
>>Thanks Paul
>
>Try this:
>
>=sqlexec(gconnect,"execute client_retrieve_funds_s card_number,return_code ")
>
>Pierre
Thanks Pierre
It actually turns out to be the same syntax as for MS SQL.
return_code = 0 && set the variable type
=sqlsxec(gconnect,"{call client_retreive_funds_s(54321, ?@return_code)}")
Live and learn(after lots of research time).
Paul
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement