>>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