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

Explian rowid, rownum? What are the psoducolumns we have?

565

What is the use of <> sql?

548

what are the types of subquery? : Sql dba

584

what is normalization? : Sql dba

559

Why cross join is used?

626

What is the usage of distinct keyword?

627

describe mysql connection using mysql binary. : Sql dba

548

What are the 3 modes of parameter?

675

How does a trigger work?

533

Can we create a trigger on view?

485

Does sql*plus also have a pl/sql engine?

558

Can we use update in sql function?

576

What is mutating trigger?

576

What are instead of triggers?

620

What are sql queries used for?

530