Associative Array
Hello All,
I have the following view
bsf.XX_CURSPOT_ASS_ARRAY (CUR_DATE varchar(13), exch_rate number(13,8));
declare
-- Local variables here
i integer;
a varchar2(50);
TYPE CURR_RATE_TAB IS TABLE OF BSF.XX_CURSPOT_ASS_ARRAY%ROWTYPE INDEX BY VARCHAR2(13);
V_CURR_RATE CURR_RATE_TAB;
CURSOR S IS
SELECT *
FROM BSF.XX_CURSPOT_ASS_ARRAY A
WHERE A.CUR_DATE = 'EGP-10-JAN-12';
begin
FOR V IN S LOOP
V_CURR_RATE('EGP-10-JAN-12') := .62112;
END LOOP;
end;
This code will raise the following error :
ORA-06550: line 16, column 36:
PLS-00382: expression is of wrong type
ORA-06550: line 16, column 4:
0