11

Error Handling using ISQL for oracle connection in Perl

view full story
linux-howto

http://www.unix.com – 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_pa (HowTos)