1 Reply Latest reply: Aug 18, 2013 4:45 AM by odie_63 RSS

    Help in using record type and object type


      Hi Experts,


      I am new to object types and record types.


      I want to return the output of this query using one OUT parameter

      from the procedure using RECORD type or OBJECT type.

      without using refcursor.


      SELECT empno,ename,sal FROM emp WHERE deptno=30;


      Let us assume the query is returning 50 records.

      I want to send those 50 records to OUT parameter using record type or object type.

      Please provide the for the requirement code using RECORD TYPE and OBJECT TYPE separately.


      Your earliest response is appreciated.


      Thanks in advance.