0

A question regarding stored procedure in oracle.
Consider there are two procedures A and B, Procedure A computes and provides a certain number of rows, think it is kind of result set.
I need to pass all these rows to Procedure B as input.
Can I do this with out using Collections like Nested Table or Index By Table or Ref Cursor.

Praveen
  • 8,945
  • 4
  • 31
  • 49
Dark Knight
  • 11
  • 2
  • Why would you not want to use ref cursors or collections? You could use a delimited VARCHAR2 but that would get horrible very quickly... – Ollie Sep 14 '15 at 09:23
  • This may help you... http://www.experts-exchange.com/questions/28310653/Pass-the-Result-Set-of-One-Stored-Procedure-into-a-Second-Stored-Procedure-as-an-Input-Parameter.html – Dark Knight Feb 29 '16 at 12:32

0 Answers0