PL/SQL (MOSC)

MOSC Banner

Associative Array

edited Feb 17, 2013 7:00PM in PL/SQL (MOSC) 1 commentAnswered


  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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center