OraFAQ Forum: SQL & PL/SQL » in , out parameter problem

Home » SQL & PL/SQL » SQL & PL/SQL » in , out parameter problem

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

in , out parameter problem [message #41209]

Tue, 10 December 2002 05:17

Gurdeep Singh
Messages: 64
Registered: October 2002

Member

i have problem

create or replace procedure p(a number ,b out number) as
begin
select sal into b from emp where empno=a;
end;
/
please tell me how to run this procedure to retrieve the value of b.
Thanks

Report message to a moderator

Re: in , out parameter problem [message #41210 is a reply to message #41209]

Tue, 10 December 2002 05:24

Maaher
Messages: 7065
Registered: December 2001

Senior Member

[code]declare
v_empno number := &num;
v_sal number;
begin
p(v_empno, v_sal);
dbms_output.put_line(v_sal||' is the salary of employee '||v_empno);
end;
/

MHE

Report message to a moderator

Re: in , out parameter problem [message #41212 is a reply to message #41209]

Tue, 10 December 2002 06:14

Gilbey
Messages: 87
Registered: March 2002

Member

1]   Declare b at SQL prompt as "variable b number";
2]   run the procedure p
3]   print the value of b at SQL prompt as "print b"

Report message to a moderator

Re: in , out parameter problem [message #41219 is a reply to message #41209]

Tue, 10 December 2002 21:50

oraquest
Messages: 1
Registered: December 2002

Junior Member

you can declare variable for the value and print it directly using the DBMS_OUTPUT utility or if required print it into a data file using UTL_FILE utility.

Report message to a moderator

Previous Topic:	LIKE and 2 SELECTS...
Next Topic:	Pls help me out

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 06:27:45 CDT 2024