If you have something like $dbh->do(); You can get the error code with $dbh->err and the full error message with $dbh-errstr .
for more info: http://search.cpan.org/~timb/DBI/DBI.pm#err On Mon, Nov 9, 2009 at 5:37 AM, Parag Kalra <[email protected]> wrote: > Hello All, > > This is my first post here. > > I am executing a Perl script which makes use of 'DBI' module. > > I am performing a select operation on a table through the Perl script and I > am getting following error on the console: > > DBD::ODBC::st execute failed: [Oracle][ODBC][Ora]ORA-00942: table or view > does not exist > (SQL-42S02) at Test.pl line 67 > > The error message is well justified as the table doesn't exist. > > However I just wanted to know if there is a way to catch this error message > through some variable so that I can print it in a log file as well. > > Cheers, > Parag >
