how do u call in & out parameters for stored procedures?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / vamshi

10 Answers
19594 Views
A1 Technology, TCS, Techicon, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how do u call in & out parameters for stored procedures?..

Answer / sudhir kumar singh

procedure_name(a in number,b out varchar)
(
script of execution;

)
exec procedure_name(first_parameter,second_parameter);

Is This Answer Correct ?

16 Yes

3 No

how do u call in & out parameters for stored procedures?..

Answer / soujanya

See the example below...

create or replace procedure addn(a in number,b in number, c
out number)
is
begin
c:=a+b;
dbms_output.put_line(c);
end addn;

Now we can call the in and out parameters as

declare a variable for the out parameter as

var n number;
exec addn(5,10,:n);
print n;

Is This Answer Correct ?

9 Yes

1 No

how do u call in & out parameters for stored procedures?..

Answer / mohana sundaram

create or replace procedure p_name(p_no in out number)
is begin
{
executable statement
}
end p_name;
/

Is This Answer Correct ?

8 Yes

4 No

how do u call in & out parameters for stored procedures?..

Answer / sangeetha

create or replace procedure <pocedure_name>(x in number,y
out varchar) is begin
{
executable statements;

}
end <procedure_name>;

exec <procedure_name>(first_parameter,second_parameter);

Is This Answer Correct ?

6 Yes

3 No

how do u call in & out parameters for stored procedures?..

Answer / susila

create or replace procedure <pocedure_name>(x in number,y
out number) is begin
{
executable statements;

}
end <procedure_name>;

exec <procedure_name>(10,y);

Is This Answer Correct ?

5 Yes

2 No

how do u call in & out parameters for stored procedures?..

Answer / sangeetha

<procedure_name>(in_parameter_value,
out_parameter_variable);

Is This Answer Correct ?

4 Yes

2 No

how do u call in & out parameters for stored procedures?..

Answer / venkat soma

Thanks yaar !!!!!!!!

Is This Answer Correct ?

3 Yes

2 No

how do u call in & out parameters for stored procedures?..

Answer / madhav

create or replace procedure proc_in_out
(p_empno in number,p_ename out varchar2)
as
begin
.......
.......
end;
execute proc_in_out(7369,p_ename)--out parameter can't
like this

declare
v_ename varchar2(10);
begin
proc_in_out(7369,v_ename);
end;

Is This Answer Correct ?

1 Yes

0 No

how do u call in & out parameters for stored procedures?..

Answer / rajasekar.g

matrial purchase is in and matrial sales is out for stored
procedure

Is This Answer Correct ?

0 Yes

0 No

how do u call in & out parameters for stored procedures?..

Answer / ajit

create or replace procedure P_io ( I_num1 number,
o_num2 out number,
io_num3 in out number
)
is
begin
io_num3 := io_num3 + i_num1;
o_num2 := io_num3;
end;
/

Call this store procedure
--------------------------
declare
a number := 3;
b number;
c number := 7;
begin
P_io ( a, b, c);
dbms_output.put_line ( a||' '||b||' '||c);
end;
/

Is This Answer Correct ?

0 Yes

0 No

Post New Answer