Home » SQL & PL/SQL » SQL & PL/SQL » Nested Table problem(URGENT)
Nested Table problem(URGENT) [message #38435] Wed, 17 April 2002 13:27 Go to next message
ranjan
Messages: 20
Registered: August 1999
Junior Member
Hi,
In a procedure, I am using
TYPE parm_tab IS TABLE OF parm_obj;
where parm_obj is an object type
type parm_obj as object(parm_desc VARCHAR2(500), parm_value VARCHAR2(500));

v_data parm_tab := parm_tab();

when I am trying to do

v_data( v_data.count).parm_desc := 'Test';

I am getting the following error.

ERROR at line 1:
ORA-06530: Reference to uninitialized composite

Please suggest...
Re: Nested Table problem(URGENT) [message #38471 is a reply to message #38435] Fri, 19 April 2002 07:39 Go to previous message
Jay Ramlakan
Messages: 11
Registered: April 2002
Junior Member
Change
v_data( v_data.count).parm_desc := 'Test';

To
v_data(v_data.count) := parm_obj('Test', null);

v_data is a table of object type parm_obj. You have to use the constructor to set it's values.

Let me know how it goes,
-Jay
Previous Topic: Error using Objects
Next Topic: Transaction Clarification
Goto Forum:
  


Current Time: Sat Apr 27 00:50:41 CDT 2024