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 -> Re: Index-by table - compilation errors

Re: Index-by table - compilation errors

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 06 Jun 2007 08:00:04 -0700
Message-ID: <1181142003.818855@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:00:04 CDT

Original text of this message

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