Oracle array gives undefined variable

Question

I am fairly new to Oracle and I have been googling this for the whole day.

I declared some arrays in a stored proc in Oracle using the code below

procedure process_shipping_order (i_shor_id in x_shipping_order.shor_id%type, o_error_text out varchar2)

is
type t_numbercoll is table of number index by pls_integer;
type t_varchar2coll is table of varchar2 (100) index by pls_integer;
tv_count t_numbercoll;
Begin
  ....
end process_shipping_order

When I execute this code I get an error stating that t_numbercoll, t_varchar2coll, and t_numbercoll are undeclared variable. Can you please help me figure out what I am doing wrong. I am using Toad for Oracle. My Oracle version is 10.2.

Regards

Please, give the full text of code that you executed. These examples have no errors, but you need to use them in right place. — Dmitriy
– Dmitriy, Commented Nov 27, 2014 at 15:39

Jeffrey Kemp · Accepted Answer · 2014-11-28 00:45:44Z

1

t_numbercoll, t_varchar2coll, and t_numbercoll are the names of your types, not variables - so if your procedural code between BEGIN..END (which you still haven't posted) refers to them, Oracle will raise a compilation error.

answered Nov 28, 2014 at 0:45

Jeffrey Kemp

60.5k15 gold badges111 silver badges161 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle array gives undefined variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related