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

Home -> Community -> Usenet -> c.d.o.server -> Index-by table - compilation errors

Index-by table - compilation errors

From: Vojta <ryvo_at_centrum.cz>
Date: Wed, 6 Jun 2007 16:41:18 +0200
Message-ID: <f46h2o$t7m$1@ns.felk.cvut.cz>


Please, can you advise? I created package in which I defined type:

TYPE StrListTyp IS TABLE OF VARCHAR(255) INDEX BY BINARY_INTEGER;

Package was created, it works, procedures can work with this type. Then I tried to create the same type outside package by executing script:

CREATE OR REPLACE TYPE StrListTyp IS TABLE OF VARCHAR(255) INDEX BY BINARY_INTEGER; Type is created with warning: "Warning: TYPE created with compilation errors". When I try to run procedure using this type I get error "Object [procedure name] is invalid". If I run the script without "INDEX BY", type is created without wornings but indexing does not work:

CREATE OR REPLACE TYPE StrListTyp IS TABLE OF VARCHAR(255);

CREATE PROCEDURE MyProc IS
strList StrListTyp := StrListTyp();
BEGIN
  strList(1) := 'ABC'; -- Here I get error "Lower index exceeds counter" END; Please, what do I do wrong? How can I create index-by table outside package?

Thank you! Vojta Received on Wed Jun 06 2007 - 09:41:18 CDT

Original text of this message

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