random error : ORA-06530: Reference to uninitialized composite
Date: 30 Oct 2001 12:15:56 -0800
Message-ID: <7ce86370.0110301215.4db75fcc_at_posting.google.com>
I am getting an error in a stored procedure. The scenario is as
follows.
We are doing a data migration from a Legacy system to newer system.
This work
requires loading of data in flatfile format from the Legacy system to
the newwe system. Currently we are facing a problem(once in a while)
while loading the records. We faced it couple of times(number of
records in the data input file : 60). The error is as follows.
6530 ret_lava_dat.c 643 -6530 ORA-06530: Reference to uninitialized
composite
ORA-06512: at "ADDS.PKG_RET_LAVA_DAT", line 179
ORA-06512: at line 1
These records partially loded into few tables. We deleted those
partial data
and tried to load again, and it went through. In a different machine
we didn't
get this error at all with the same data.
We some time run multiple instances of this program also. It is hard
to reproduce this error. It is really appreciated if anybody can help
me out from this error.
-Sajith Received on Tue Oct 30 2001 - 21:15:56 CET