procedure_name(a in number,b out varchar) ( script of execution;

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

Question Posted / sudhir kumar singh

Answer Posted / sudhir kumar singh

procedure_name(a in number,b out varchar)
(
script of execution;

)
exec procedure_name(first_parameter,second_parameter);

Is This Answer Correct ?

16 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what is cross join? : Sql dba

568

Why are cursors used?

578

What is restrict in sql?

554

what is data manipulation language? : Sql dba

527

Can you inner join the same table?

525

What is sqlca in powerbuilder?

560

How to take user input in pl sql?

699

How to add a column ‘salary’ to a table employee_details?

583

what is sql? : Sql dba

557

What is rowtype?

562

What is full form of rtm?

530

Is sql sequential or random?

535

What is union and union all keyword in sql and what are their differences?

571

can sql servers linked to other servers like oracle? : Sql dba

548

Compare sql & pl/sql

602