Cast seems to be unavailable for inner types...
I can't figure out how to read my inner table/array with a cursor...
DA Morgan <damorgan_at_x.washington.edu> wrote in message news:<1114011928.9659_at_yasure>...
> 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.
Received on Thu Apr 21 2005 - 02:02:21 CDT
