Thanks to All.. It did the trick for me - http://search.cpan.org/~timb/DBI/DBI.pm#$DBI::errstr<http://search.cpan.org/%7Etimb/DBI/DBI.pm#$DBI::errstr>
Cheers, Parag On Mon, Nov 9, 2009 at 6:43 PM, Arun G Nair <arungn...@gmail.com> wrote: > On Mon, Nov 9, 2009 at 6:37 PM, Parag Kalra <paragka...@gmail.com> 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 standard DBI variable so that I can print it in a log file > as > > well. > > Cheers, > > Parag > > > > http://search.cpan.org/~timb/DBI/DBI.pm#$DBI::errstr<http://search.cpan.org/%7Etimb/DBI/DBI.pm#$DBI::errstr> > > > -- > ...Keep Smiling... >
