no support of varchar2-indexed arrays?

[jmueller]

PL/SQL Developer doesn't seem to support
index-by tables indexed with varchar2
(new in Oracle 9i.2), i.e.declarations like the following:

TYPE itree_table_type IS TABLE OF
itree_rec_type
INDEX BY VARCHAR2(50);

On compilation I receive PLS -00222 error.
currently I'm using version 5.1.3.704
Is there help?
Yours sincerely,
Dr. Jakob M

 

[Marco Kalter]

If I try this on Oracle 9.2 it works okay. If I try the same on Oracle 9.0, I get PLS-00222 as expected.

Are you sure your Oracle Server is 9.2 and that the COMPATIBLE initialization parameter is set to 9.2?

------------------
Marco Kalter
Allround Automations

 

[jmueller]

Thanks. I forgot about the basics...