populate cursor with array

From: Franck <wesley.saris_at_gmail.com>
Date: 20 Apr 2005 06:10:58 -0700
Message-ID: <74e7fd2c.0504200510.242baca@posting.google.com>

Hi,
got my stored procedure like this :
create or replace procedure CIDR_GET_PERFORMANCE( issue_number IN VARCHAR2,
date_start IN VARCHAR2,date_end IN VARCHAR2, C_RESULT OUT Cv_Types.GenericCurTyp)

with local types
TYPE performance_row IS RECORD(

                     strSecurityId varchar(11):= issue_number,
                     dateCurrentMonth varchar(10), lngPerformance number);

TYPE performance_array is VARRAY(1200) of performance_row;

and private statement
oPerfArray performance_array;

How can I populate C_RESULT with oPerfArray ?

I tried "OPEN C_RESULT FOR

       SELECT *
       FROM TABLE ( CAST ( oPerfArray AS performance_array));"

But it does not work.

Thks for help. Received on Wed Apr 20 2005 - 08:10:58 CDT