RE: How to discard the error in SQL query

2010-04-30 Thread John Scoles
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: db

Re: How to discard the error in SQL query

2010-04-30 Thread Bruce Johnson
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 T

Re: How to discard the error in SQL query

2010-04-30 Thread Parag Kalra
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 wro

Re: How to discard the error in SQL query

2010-04-30 Thread Ovid
- Original Message > From: Parag Kalra > 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 doesn't seem to