Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re^3: Passing a file into DBD-Oracle

by TJRandall (Sexton)
on Feb 11, 2011 at 22:07 UTC ( [id://887691]=note: print w/replies, xml ) Need Help??


in reply to Re^2: Passing a file into DBD-Oracle
in thread Passing a file into DBD-Oracle

Overall, what I'm trying to do is to automate Oracle code builds. I check out the files locally, and then I load up a hash of hashes to keep track of what I'm loading, the compiled state, etc. So one of the key:value pairs for a named piece of code is 'full_name':'c:\..\..\..'. The files that I am working on contain Oracle functions, procedures, packages, etc.

I didn't mean to be mis-leading in the Subject line - I would either (1) pass the actual file into DBI (like SQL Plus) or (2) read in the file contents, and then prepare() that. I just can't seem to get either to work. I will work on the suggestion from roboticus (thank you very much!) It didn't work on the first pass, but I will focus on the  undef issue. Thank you!

Replies are listed 'Best First'.
Re^4: Passing a file into DBD-Oracle
by bart (Canon) on Feb 11, 2011 at 22:54 UTC
    Overall, what I'm trying to do is to automate Oracle code builds.
    I think your best bet is to invoke Sql*Plus from within Perl.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (6)
As of 2024-04-19 10:07 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found