Re: Index-by table - compilation errors

Hello,

my problem is compilation warning "Warning: TYPE created with compilation errors" in script:

CREATE OR REPLACE TYPE StrListTyp IS TABLE OF VARCHAR(255) INDEX BY BINARY_INTEGER; After that my procedure, which is using the type, becomes invalid. What is wrong on the script?

When I execute script:

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

type is created without warnings but then I get error "Lower index exceeds counter" in procedure when I try to assign value to StrListTyp(index) .

"DA Morgan" <damorgan_at_psoug.org> píse v diskusním príspevku news:1181142003.818855_at_bubbleator.drizzle.com...
> Vojta wrote:
>> 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
>
> Why? The error message you have been looking at is well written and
> quite clear on the matter. What is the business case that makes you
> want to circumvent it?
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Wed Jun 06 2007 - 10:14:13 CDT