Problem in implementation of executeBatch method having a voluminous batch
0 posts in topic
Flat View  Flat View

Posted By:   Ajay_Bhide
Posted On:   Saturday, March 24, 2001 06:12 AM

I was trying to insert values in a table having five columns.
The ststement was 'INSERT INTO temp_table VALUES('a','b','c','d','e');' in a for loop for 1000 times
just for checking the performance.
But I encountered an error from Oracle database ver. 8.1.6.
The error codes were ORA-06550 and PLS-0123.
And when I reduced the no. of statements to 546 ( a randon no.) the result was a success.
I have not tried at the exact no. of the statements at which the Oracle will not give the
above mentioned error and after which it will start giving error.
So please anyone will guide me.

About | Sitemap | Contact