Re: populate cursor with array

Franck wrote:

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

One solution:

http://www.psoug.org
click on Morgan's Library
click on Bulk Collection

Look at the examples using arrays.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)