first declare a variable globaly and next create inner procedure with in(i

How can I pass the inner procedure value to outer
procedure ?

Question Posted / s.syam sundar

2 Answers
7457 Views
I also Faced
E-Mail Answers

Answer Posted / s.syam sundar

first declare a variable globaly
and next create inner procedure with in(if need or u can
set defult parameters) and out parameters
and next result of inner procedure is assigned to global
variable
and next in outer procedure u can get the result from global
variable

regads
S.syam sundar

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is bulk collect in pl sql?

1021

How many commands are there in sql?

972

How to add new employee details in an employee_details table with the following details

1043

What is the difference between database trigger and stored procedure?

1007

What are all different types of collation sensitivity?

975

differentiate between float and double. : Sql dba

992

Explain autonomous transaction.

1095

What is the unique index?

1005

What is insert command in sql?

1061

What is compute?

1016

Cite the differences between execution of triggers and stored procedures?

1031

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3010

How to load data with sql*loader?

1000

What is the difference between explicit and implicit cursors in oracle?

999

What is a ddl command?

1008