On 06/06/2005 02:06 PM, Peter Rabbitson said:
On Mon, Jun 06, 2005 at 01:11:30PM -0700, Vergara, Michael (TEM) wrote:
I want to connect to an Oracle database and test for the existence of a table. My first thought was to SELECT COUNT(*) FROM TABLE, but DBI catches the ORA-942 error and I don't know how to catch that. It throws the error during the $dbh->execute step; how do I catch an Oracle error returned from that step? Or...is there a better way?
Yes there is, and it is even portable (or so they say) across different vendors. Look for the table_info () method at http://search.cpan.org/~timb/DBI-1.48/DBI.pm#Database_Handle_Methods
Note that the same manual page also describes how to catch errors. You can also see the same page by running `perldoc DBI` from the command prompt. perldoc works for most other Perl modules and you can see everything about the modules in CPAN (http://search.cpan.org/).
-- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
