Is there anyway to declare a RECORD TYPE dynamically based on what is returned into a REF CURSOR?
Also is there anyway of accessing the fields of a RECORD by script rather than by name? i.e Recordname.(0) instead of Recordname.Fieldname.
The folowing example will call a different Stored Procedure based on the number passed in. The different SP's will all return Ref Cursors but they will be Constructed from different SQL statements and Tables. How do i then access the differing information in the CURSOR??? Hope that makes sence
CREATE OR REPLACE PROCEDURE spTest (condition IN NUMBER)
TYPE TypeRefCur IS REF CURSOR;
RetRefRecord Declared Dynamically based what will be
returned by to RetRefCursor
based on the number passed in different stored procedures will be
called that will return a ref cursor which will be generated from
differnt tables. Then want to:
FETCH RetRefCursor INTO RetRefRecord
Access all information in RetRefRecord