in reply to Re^2: Multiple sql statements in one sql file
in thread Multiple sql statements in one sql file

leo_jeo:

What are you using for the input file, and what error message(s) are you getting when you run it. (I don't use DBIx, so I'm concentrating on the first one.)

If you're using the same file from the original post, you'll need to strip out the non-SQL bits before trying to run it.

...roboticus

When your only tool is a hammer, all problems look like your thumb.

  • Comment on Re^3: Multiple sql statements in one sql file

Replies are listed 'Best First'.
Re^4: Multiple sql statements in one sql file
by leo_jeo (Initiate) on Nov 30, 2011 at 16:26 UTC

    Thanks roboticus !! This guidance "If you're using the same file from the original post, you'll need to strip out the non-SQL bits before trying to run it." worked like a charm. Thanks a lot,I am good now.

[reply]
Re^4: Multiple sql statements in one sql file
by leo_jeo (Initiate) on Dec 06, 2011 at 04:48 UTC

    Thanks Roboticus, this resolved the problem. I removed the sqlplus related code and handled LOB and did the text operations in perl and bang I got the result. Thanks a lot!!

[reply]

In Section Seekers of Perl Wisdom