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

Why stored procedures are faster than query?

570


Who is the owner of mysql database?

553


What are local and global Indexes and where they are useful.

930


What is rownum in sql?

561


Can we use threading in pl/sql?

521






what is a constraint? Tell me about its various levels. : Sql dba

564


What are instead of triggers?

628


Is not equal in sql?

571


What is sql not null constraint?

606


What are the different tcl commands in sql?

624


How do I filter in sql profiler?

538


What port does sql server use?

510


Are stored procedures faster than queries?

524


What is dynamic sql in pl sql?

497


What is pivot table in sql?

526