Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re^3: Multiple sql statements in one sql file

by roboticus (Canon)
on Nov 29, 2011 at 10:44 UTC ( #940576=note: print w/ replies, xml ) Need Help??


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
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.

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!!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://940576]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (8)
As of 2014-07-28 09:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (193 votes), past polls