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

Does truncate need commit?

1005

What are the two virtual tables available at the time of database trigger execution?

1272

Is foreign key mandatory?

1064

What is auto increment?

1045

How many parts of a pl sql block are optional?

1219

What are reports usually used for?

1085

How much does a sql dba make? : SQL DBA

988

How does join work in sql?

1053

What is sql integrity?

1242

What is trigger in sql and its types?

1113

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

998

What is mutating trigger?

1073

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1162

What is the use of <> sql?

1038

How many tables can a sql database have?

1029