Elaborate the error ORA-06531 while running the below query ?

Question

question

OracleApprender asked Feb 5, '10

Elaborate the error ORA-06531 while running the below query ?

I'm recieving the below error msg while running the query. Please can one elaborate it further. Thank you in advance.

SQL> declare
2     TYPE test IS VARRAY(6) OF VARCHAR2(20) ;
3 begin
4     dbms_output.put_line('test value is '||test(1));
5 end;
6 /
declare
*
ERROR at line 1:
ORA-06531: Reference to uninitialized collection
ORA-06512: at line 4

query oracle

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-02-05T08:17:31Z

Andrew Mobbs answered Feb 5, '10

You haven't initialized a collection variable, just defined the type.

To create a variable (v_test) of the collection type you've defined do something like:

 v_test test := test('foo');

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question