Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Index-by table - compilation errors
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