Hi All,
I am executing list of SQL queries from a file. Currently if there is any
error (like syntax issue) in any of the sql query it doesn't processes the
other remainig queries.
I tried executing the queries in 'eval' but it doesn't seem to work. I am
using DBI and DBD::Oracle
Cheers,
Parag
- Original Message
From: Parag Kalra paragka...@gmail.com
I am executing list of SQL queries from a file. Currently if
there is an error (like syntax issue) in any of the sql query it doesn't
processes the other remainig queries.
I tried executing the queries in 'eval' but it
I am executing simple insert SQL queries in a loop
I have a simple requirement - While insert quieries are being executed, if
any error occurs it should print that message and move to next insert sql
query. I am using DBD::Oracle on Unix
Cheers,
Parag
On Fri, Apr 30, 2010 at 1:10 PM, Ovid
On Apr 30, 2010, at 1:26 PM, Parag Kalra wrote:
I am executing simple insert SQL queries in a loop
I have a simple requirement - While insert quieries are being
executed, if
any error occurs it should print that message and move to next
insert sql
query. I am using DBD::Oracle on Unix
This is a case of RTFM
http://search.cpan.org/~timb/DBI-1.611/DBI.pm#PrintError_(boolean,_inherited)
PrintError will just print the error and go on its merry way
From: paragka...@gmail.com
Date: Fri, 30 Apr 2010 12:39:38 -0700
Subject: How to discard the error in SQL query
To:
