Unanswered: Call a stored procedure from another stored procedure?
Is it possible to call a stored procedure from another stored procedure and pass a reference cursor? Perhaps if I lay out the sequence of events that I want to follow someone can help me:
I am using a stored procedure that needs to return a recordset with 126 columns. Some of these values can be extracted from a table, but others need to be calculated from the values extracted from the table.
I want a secondary stored procedure to extract the values from a table; I want this secondary stored procedure to be called by a primary stored procedure.
The primary stored procedure needs to be able to use the columns from a reference cursor returned from the secondary stored procedure both to display these values, and to calculate new values with some simple math.
The primary procedure needs to return a reference cursor.
Could someone give me some idea how to do this, particularly the calling of a second stored procedure, the declaration of reference cursors and how to reference columns that are returned from the called stored procedure.
Sorry to have asked such a complex question, but I am moving from SQL Server to Oracle, and I am expected to move at breakneck speed whilst learning it!