In addition to the advice you have received, I might suggest that you read all of the user documentation for both DBI and DBD::Oracle.
You'll be glad you did. It is a good idea to review it periodically as well. Which reminds me ... Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com On Mon, Nov 9, 2009 at 2: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 >
