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

How is a process of pl/sql compiled?

775


What does <> sql mean?

711


What is sql and its types?

813


How to start the command-line sql*plus?

743


How is pl sql different from sql?

726






What is sorting in sql?

673


Why do we need unique key in a table?

673


Is postgresql a nosql database?

791


Define tables and fields in a database

833


Does inner join return duplicate rows?

701


How many postgresql users are there, worldwide?

779


How to use sql statements in pl/sql?

798


what are aggregate and scalar functions? : Sql dba

734


Write the command to remove all players named sachin from the players table.

922


Is hadoop a nosql?

745