Calling an Oracle stored procedure from JAM jpl

From: Steve Musgrave <musgse_at_meaddata.com>
Date: 10 Sep 1993 14:59:21 GMT
Message-ID: <26q4o9$rh0_at_meaddata.meaddata.com>


I have called Sybase stored procedures from JAM jpl but I am getting syntax errors when I call an Oracle stored procedure.

oracle is the database owner
test_package is our package
signon is our stored procedure which has two char parameters

I have tried different syntaxes but none of them seem to work.

   sql oracle.test_package.signon( 'Steve', 'Musgrave' )    sql EXEC oracle.test_package.signon( 'Steve', 'Musgrave' )    etc...

Can someone tell me the correct syntax?

--

* Steve Musgrave (musgse_at_meaddata.com) *
* I want to live as an honest man, to get all I deserve and to *
* give all I can, and to love a young woman I don't understand. *
* Suzzanne Vega's "The Queen and the Soldier" *
Received on Fri Sep 10 1993 - 16:59:21 CEST

Original text of this message