Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Inconsistent behavior between SQL*Plus and Perl DBI
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
![]() |
![]() |