How can I pass the inner procedure value to outer
procedure ?
- 2 Answers
- 6639 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
How do I truncate a word?
What is the maximum number of columns in sql table?
what is the difference between char_length and length? : Sql dba
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is error ora-01000: maximum open cursors exceeded
How does rowid help in running a query faster?
What are %type and %rowtype for?
What is interval partition?
what are all types of user defined functions? : Sql dba
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What's the procedure?
How to display Row Number with Records in Oracle SQL Plus?
What are the usages of sql?
