OraFAQ Forum: SQL & PL/SQL » How do I call stored procedure with IN and OUT parameter?

Home » SQL & PL/SQL » SQL & PL/SQL » How do I call stored procedure with IN and OUT parameter?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How do I call stored procedure with IN and OUT parameter? [message #39478]

Thu, 18 July 2002 11:08

Moneim
Messages: 1
Registered: July 2002

Junior Member

How do I call a stored procedure thal looks like this

CREATE OR REPLACE PROCEDURE UIL_QUERYACCOUNTS(
UIN IN keymappinginfo.keyvalue%TYPE,
Return_Status OUT keymapp.keyvalue%TYPE,
FIRSTNAME OUT mytable.firstname%TYPE,
LASTNAME OUT mytable.firstname%TYPE)
IS
....

thanks

Report message to a moderator

Re: How do I call stored procedure with IN and OUT parameter? [message #39479 is a reply to message #39478]

Thu, 18 July 2002 11:30

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

How do you call it from what? Every environment will be different, but here is a SQL*Plus example (that does not show the output/results):

sql>var v_uin number
sql>var v_return_status number
sql>var v_firstname varchar2(30)
sql>var v_lastname varchar2(30)
 
sql>exec uil_queryaccounts(:v_uin, :v_return_status, :v_firstname, :v_lastname);
 
sql>print v_uin
sql>print v_return_status
sql>print v_firstname
sql>print v_lastname

Report message to a moderator

Previous Topic:	Re: check out please
Next Topic:	reset sequence on sysdate

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 21:38:14 CDT 2024