This discussion is archived
1 Reply Latest reply: Aug 18, 2013 2:45 AM by odie_63 RSS

Help in using record type and object type

ramya_162 Newbie
Currently Being Moderated

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.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points