UNIX for Dummies Questions & Answers

Hi

Am making connection to oracle using ISQL as shown in the code.
This code is just a minor part of a big code.
I want to capture the error if the password/login is wrong or if connection is not made.
I need to capture the error code also.
Also, If such an error occurs, i need to exit out of the script
How can this be done in ISQL


Any help will be appreciated.
Thanks in advance.

Code:

 
my $fileLoad = <<LOADEOF;
set term off;
set linesize 1500;
set feedback off;
spool ${data_file}
$orcl_query;
spool off
LOADEOF
 
 
open (ISQL, "|sqlplus -S ${db_login}/${db_passwd}\@${oracle_sid}");
ISQL $fileLoad;
close (ISQL);

Code:

open (ISQL, "|sqlplus -S ${db_login}/${db_passwd}\@${oracle_sid}") or die "Couldn't execute program: $!";

$! will have the error information

Thanks
But how to capture the error no?

Also how can it be done using "eval"?

i guess, you will get the reason and error code in the $!

otherwise

you can use DBI module

DBI - search.cpan.org

Thanks
But die/eval/whenever sqlerror exit sql.sqlcode doesnt work.
Is there any other better option to capture the error code there itself and exit from the script?