Re: Inconsistent behavior between SQL*Plus and Perl DBI

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 20 Jul 2004 00:12:19 -0400
Message-ID: <pan.2004.07.20.04.12.17.974321@sbcglobal.net>

On Tue, 20 Jul 2004 09:44:29 +1000, Gregory Toomey wrote:

> Try printing out $temp_query after you assign it to the here doc, then cut &
> paste into sql*plus. There may be some Perl variable interpolation you did
> not expect.

Oracle has a table called USER_ERRORS in which the last compilation error is recorded. There is also a table called USER_SOURCE, from which the lines of the compiled source can be obtained. A logical step would be to extract the source of the unit that was actually compiled and compare it with the desired. Perl is a mighty tool, and I use it frequently, but it shouldn't be the only tool.

-- 
A city is a large community where people are lonesome together.

Received on Mon Jul 19 2004 - 23:12:19 CDT