Re: Referencing PL/SQL TABLE's record??

In article <7m49uk$4iv$1_at_nnrp1.deja.com>, agi_at_mail.taicom.com.tw writes
>Hi,theres
>
> I declare a PL/SQL TABLE based on a cursor, how to reference
> the PL/SQL table to retrieve the record that I want ??
> some code in my procedure as follows
>
>
> cursor ccy is select a,b,c
> from table_A
> where a = xxx;
> type cur_table is table of ccy%rowtype index by binary_integer;
> ccy_tab curcd_table;
>
> after transfering database info to pl/sql table,(if every record on
> the pl/sql table is unique)
>
> how to referencing ccy_tab.c where ccy_tab.a ='AAA'??

There isn't a 'search' function - you'll need to loop through the table until you find the record you want.

Andy

-- 
Andy Hardy. PGP key available on request
===============================================================