ORA-06530: Reference to uninitialized collection [message #223375] |
Thu, 08 March 2007 13:21  |
Ivan
Messages: 180 Registered: June 2000
|
Senior Member |
|
|
Guys,
Could you please help me with a collection problem I'm having?
Here's the code:
declare
type r is record (dt date, n pls_integer);
type tr is table of r;
type tt is table of tr;
--
lt tt := tt();
begin
lt.extend;
--
-- Need to assign values to lt(1)(1)
/*
lt(1).extend; -- returns ORA-06531: Reference to uninitialized collection
*/
null;
end;
The types are created using the CREATE TYPE command.
I need to be able to populate the LT collection one line/value at a time.
The problem is that I can't assign values to LT(1)(1) without initializing it first.
Could anyone show me how to do that, please?
Thank you in advance.
|
|
|
|
|