[SQL] How to Log SELECT Statements Having Errors

2005-11-14 Thread Lane Van Ingen
We are putting a new application on PostgreSQL 8.0.1 (Windows 2003); we are coming off of MySQL, and are having a hard time finding all of the offending SQL calls. It would help a great deal if I could log the content of any SQL calls that fail. Am only interested in SELECT statements. Noticed th

[SQL] Connection Oracle database from Postgres function

2005-11-14 Thread Dinesh Pandey
I want to access Oracle database from Postgres. One way to use DBI-LINK and use “plperl” function in Postgres to make connection with Oracle. Using that I am getting the following error.   Environment   Solaris 9 SPARC PostgreSQL 8.0 DBI-LINK Perl-5.8.5 -