Re: Q: having problem when define a table type in PL/SQL
From: Sanjay D.S. <sanjay_at_fsg.prusec.com>
Date: 1996/04/01
Message-ID: <4jpe54$78v_at_prufire4.prusec.com>#1/1
Date: 1996/04/01
Message-ID: <4jpe54$78v_at_prufire4.prusec.com>#1/1
qix_at_wam.umd.edu (xicheng qi) wrote:
>Hi group, I am having a problem when try to define a table type in
>PL/SQL. The code fragment is as follows:
>
> TYPE table_type IS TABLE OF number INDEXED BY BINARY_INTEGER;
>
> error message:
> Encountered the symbol "OF" when expecting one of the following "["
> Fatal syntax error unable to recover.
>
Is It "INDEXED BY" or "INDEX BY", also check if your are running PL/SQL 2.0 and
above.
Sanjay D.S.
Oracle Consultant
Prudential Securities, Inc.
Received on Mon Apr 01 1996 - 00:00:00 CEST