how do u call in & out parameters for stored procedures?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
Answer / sangeetha
<procedure_name>(in_parameter_value,
out_parameter_variable);
Is This Answer Correct ? | 4 Yes | 2 No |
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 |
Answer / rajasekar.g
matrial purchase is in and matrial sales is out for stored
procedure
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
How to get list of all tables from a database?
What are the data types allowed in a table?
What is cartesian join in sql?
Is crud a cuss word?
how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00
how do you login to mysql using unix shell? : Sql dba
how to drop an existing table in mysql? : Sql dba
What is difference between stored procedure and trigger?
What is a cursor for loop ?
What is trigger explain with example?
What is a delimiter in sas?
Explain the the update statement in sql?