create or replace procedure p_name(p_no in out number) is begin { execut

how do u call in & out parameters for stored procedures?

Question Posted / mohana sundaram

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is dense_rank in sql?

986

Inline the values in PL/SQL, what does it mean.?

1227

what is error ora-03113: end-of-file on communication channel?

1165

What is the difference between count 1 and count (*) in a sql query?

994

What is pl sql architecture?

959

What is a unique key?

1055

What are the commands used in sql?

1079

What does the hierarchical profiler does?

1058

What are the main features of cursor?

1071

How do I order by ascending in sql?

1021

What is a primary key sql?

1042

What do you understand by case manipulation functions?

1034

How many commands are there in sql?

1028

Does a join table need a primary key?

953

What does the acronym acid stand for in database management?

1032