Hello Perl Monks,
I have a task to fill in huge amounts of Data in my Database. Almost about 100 Million records as quickly as possible. To achieve this, I'm using Parallel::ForkManager, which I had always used without any trouble. When I use the same module for inserting records, I get the following error.
ORA-24550: signal received: Unhandled exception: Code=c0000005 Flags=0
Please find my code structure below
use DBI;
use DBD::Oracle;
use Parallel::ForkManager;
my $pm = Parallel::ForkManager->new(MAX_PROCESSES);
my $pid = $pm->start and next;
my $check = &doInsert($x,$y,$z);
$pm->finish; # Terminates the child process
sub doInsert {
......
.....
INSERT INTO TABLE .........
}
I have searched in various blog posts, and found one of the remedies, which actually does not work, but it will just disable the error message which shows up on the console...
which is setting these flags off in the Oracle 11.2 Client "sqlnet.ora" file
DIAG_ADR_ENABLED=OFF
DIAG_SIGHANDLER_ENABLED=FALSE
DIAG_DDE_ENABLED=FALSE
Is there any solution to the above problem.
Rewards to the person who helps me out with this issue.... :)