Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Declaring a global table in PL/SQL

Declaring a global table in PL/SQL

From: absinth <absinth_at_gmail.com>
Date: 3 Aug 2005 20:47:47 -0700
Message-ID: <1123127267.302217.159800@g49g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US