Re: Script to test connecting to Oracle DBs

John D Groenveld <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Message-ID <[email protected]> 
In message <CAMnMhCCsuWB1cy3ruMcE5ZrX635HMs6XnJXuVV6WvJZ9HePDHA@mail.gmail.com>
, newbie01 perl writes:
>test connection to the Oracle DB and run a simple SQL like SELECT COUNT(1)
>from USER_TABLES, if I get an error, that means there is an issue

I would try the DBI connect and ping methods with DBD::Oracle
linked against a modern Oracle Instant Client.

Happy hacking,
John
[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.