Re: Inconsistent behavior between SQL*Plus and Perl DBI

From: John <jpeter1978_at_yahoo.com>
Date: 23 Jul 2004 08:11:43 -0700
Message-ID: <545336be.0407230711.49b198c5@posting.google.com>

Gregory Toomey <nospam_at_bigpond.com> wrote in message news:<1265282.LFvGq1lU9c_at_GMT-hosting-and-pickle-farming>...
> John wrote:
>
> ...
> > Oddly enough, if I print out this command and paste it into SQL*Plus,
> > the procedure is created and works as expected.
> ...
>
>
> 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.

Been there, done that. Apparently I didn't make that clear.

>
> gtoomey
Received on Fri Jul 23 2004 - 10:11:43 CDT