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)
IS
TYPE TypeRefCur IS REF CURSOR;
RetRefCursor TypeRefCur;
RetRefRecord Declared Dynamically based what will be
returned by to RetRefCursor
BEGIN
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:

LOOP
FETCH RetRefCursor INTO RetRefRecord
Access all information in RetRefRecord
END LOOP
END;