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

how can we submit a form without a submit button? : Sql dba

982

How many types of literals are available in pl sql?

1109

What is the order of sql select?

1040

What is the difference between the conventional and direct path loads? : aql loader

1391

Why function is used in sql?

938

How many parts of a pl sql block are optional?

1119

What is the difference between instead of trigger and after trigger?

999

How do I find sql profiler?

933

What is range partitioning?

957

What are different types of indexes?

1004

What is meant by truncate in sql?

1059

What is user in sql?

1015

What is the file extension for sql database?

997

What is the difference between pl and sql?

1089

Can we debug stored procedure?

1018