11 Replies Latest reply: Aug 19, 2013 10:02 AM by rp0428 RSS

    Help in using record type and object type

    ramya_162

      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.

      with out 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.