Pramod Shivhare

Pramod Shivhare

  • NA
  • 7
  • 13.4k

Procedure inside procedure

Jan 26 2012 8:43 AM
i have following structure of a procedures inside a package:
 PROCEDURE proc_All  
 (  
 start IN date := null,  
 end IN date := null,  
 cursor1 OUT sys_refcursor,  
 cursor1 OUT sys_refcursor,  
 cursor1 OUT sys_refcursor  );  

 PROCEDURE proc_1
 (  
 start1 IN date := null,  
 end1 IN date := null,  
 cursor1_1 OUT sys_refcursor,  );  

 PROCEDURE proc_3
 (  
 start2 IN date := null,  
 end2 IN date := null,  
 cursor1_2 OUT sys_refcursor,  );  

 PROCEDURE proc_3
 (   start3 IN date := null,  
 end3 IN date := null,  
 cursor1_3 OUT sys_refcursor,    );  

Now my requirement is that i want first procedure proc_All to call all three next procedure, as i want proc_All to be called by program. how can i pass variables to a procedure when calling inside other procedure (weather they are IN or OUT type)
can anyone please help.. thanx in advance

Answers (1)