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


Please Help Members By Posting Answers For Below Questions

What language is oracle sql developer?

508


What is the process of debugging?

547


Why coalesce is used in sql?

469


What are inner and outer joins examples of both?

494


What does the acronym acid stand for in database management?

540






How is pl sql different from sql?

540


What is a natural join?

512


Can a view be mutating? If yes, then how?

572


What is ttitle and btitle?

572


How do I create a memory optimized filegroup?

527


What is the left table in sql?

515


how do you control the max size of a heap table? : Sql dba

534


How to look at the current sql*plus system settings?

604


Can you have a foreign key without a primary key?

507


Why self join is used in sql?

495