Getting ORA-04030 Error While Executing A Procedure Having BULK COLLECT
(Doc ID 1221283.1)
Last updated on NOVEMBER 25, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Getting ORA-04030 while executing a procedure that deals with high number of historical records.
Basically this procedure used for archiving the old records. It functions by selecting the records first,then putting in a file that resides in the server, then the corresponding records will be deleted. ORA-4030 error during the SELECT phase.
The procedure uses BULK COLLECT clause as below:
FOR i IN 1 .. v_ndays LOOP
FETCH logs_1 BULK COLLECT
-- Archive oldest data into log files and delete in the main tables
FOR indx IN 1 .. v_err_msg.COUNT LOOP
IF v_flipcontrol = 0 THEN
,'Job Manually exited '
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document