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

Which is faster union or join?

972

What is the maximum rows in csv?

923

What is interval partition?

1055

What are records give examples?

1010

What are schema-level triggers?

1102

What is dynamic sql in pl sql?

1036

Can function return multiple values in sql?

1060

Why commit is not used in triggers?

1040

what are the different type of normalization? : Sql dba

1027

How many commands are in sql?

1072

Explain the commit statement.

1160

What is the difference between left join and right join?

946

What is difference between joins and union?

1127

Can we change the table name in sql?

941

What is online transaction processing (oltp)?

1017