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>
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?
--Received on Fri Sep 10 1993 - 16:59:21 CEST
* 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" *