Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Logging and and capturing sqlplus parameters and results in log

by Equest111 (Initiate)
on Sep 09, 2011 at 01:09 UTC ( #924988=perlquestion: print w/replies, xml ) Need Help??

Equest111 has asked for the wisdom of the Perl Monks concerning the following question:

I recently joined a new team that uses perl as a 'driver' to execute n number of SQL files (Oracle). However, the team is manually scripting logs prior to executing the scripts. And they are manually grepping log files for errors because flushing the buffer in the script so perl can do the grepping is too complicated. They've said it's impossible, or too hard, to have the perl script generate the log, capture stdin/std err/stdout to log file and print to screen, and grep log file up to most recent command. I'm not terribly experienced with PERL but moderately versed in other shells. This doesn't seem hard to solve but need some specific guidance so I can propose working solution to a group that will only consider a solution once and if it doesn't work will 'told you so'. Have tried t command and hot file handler. We're having trouble capturing sqlplus to log. Much Thx - living in the dark ages

  • Comment on Logging and and capturing sqlplus parameters and results in log

Replies are listed 'Best First'.
Re: Logging and and capturing sqlplus parameters and results in log
by afoken (Canon) on Sep 09, 2011 at 06:02 UTC

    There is no PERL. The name of the language is Perl, the name of the interpreter is perl. And perl is typically NOT a shell.

    In Perl, you don't want to mess with sqlplus. You use DBI and DBD::Oracle. Errors can be handled "as usual" (i.e. eval {} and $@) if you use set the RaiseError attribute of the database handle, typically by including it in the attr hash of the DBI connect method.

    Alexander

    --
    Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)
Re: Logging and and capturing sqlplus parameters and results in log
by FunkyMonk (Chancellor) on Sep 10, 2011 at 14:24 UTC

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (4)
As of 2021-12-08 00:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    R or B?



    Results (34 votes). Check out past polls.

    Notices?