How can I pass the inner procedure value to outer
procedure ?
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
What is data profiling in sql?
Which nosql database is best?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
How to raise user-defined exception with custom sqlerrm ?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is server name sql?
Does mysql_real_escape_string prevent sql injection?
Why use subqueries instead of joins?
Which one is faster ienumerable or iqueryable?
What are operators available in sql?
Why do we need view in sql?
Explain the uses of a database trigger?
What are variables in pl sql?
What are views in sql?
What is a Mapplet?