Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Declaring a global table in PL/SQL
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;
/
Received on Wed Aug 03 2005 - 22:47:47 CDT