Re: Declaring a global table in PL/SQL

absinth wrote:
> Why can't I have?
>
> CREATE OR REPLACE PACKAGE BODY test AS
> TYPE test_table IS TABLE OF VARCHAR2(30)
> INDEX BY VARCHAR2(2);
>
> DEMO_TABLE test_table;
> DEMO_TABLE('NO') := 'No';
>
> END test;
> /

Er, you can. Associative arrays were introduced back in 9i. You just need a supported version of Oracle and a BEGIN keyword ;-) Received on Thu Aug 04 2005 - 02:25:29 CDT