how do u call in & out parameters for stored procedures?
Answer Posted / 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 |
Post New Answer View All Answers
Difference between table function and pipelined function?
Is sqlite good enough for production?
Why do you partition data?
what is a constraint? : Sql dba
What is scope of pl sql developer in future?
Can procedure in package be overloaded?
What are the features of pl sql?
How to return an array from java to pl/sql?
how do you know if your mysql server is alive? : Sql dba
What is percent sign in sql?
What are inner outer left and right joins in sql?
What is sql and also describe types of sql statements?
what is uncommittable transactions? : Transact sql
What are keys in sql?
What is dba in sql? : SQL DBA