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

Don't use SQL*Plus

by Steve_p (Priest)
on Apr 16, 2004 at 18:03 UTC ( [id://345835]=note: print w/replies, xml ) Need Help??


in reply to greping errors from ORACLE

Some suggestions...

First, if this is a program reading in a log created by another real program (not the output from SQL*Plus), change the program to not report the error.

Second, if this is SQL*PLUS, and this script will be run more than once or you want to run it in a batch mode on a production system, stop what your doing with the log reading script and start writing a program that will do the work instead. SQL*Plus does not have the error handling capabilities to handle problems in a production system. You are setting your self up for a life of misery if you are attempting to use an interactive tool in a batch mode. Its fine for testing or development, but if you don't want to waste your company's or customers' money on an expensive outage, don't use SQL*PLUS.

Replies are listed 'Best First'.
Re: Don't use SQL*Plus
by pelagic (Priest) on Apr 16, 2004 at 19:22 UTC
    You shouldn't say don't use SQL*Plus.
    I'm using that thing for years and once you know to handle it, it's ok for a lot of tasks.
    And maybe the logfile was created by sqlloader which is very efficient for large amounts of data.

    pelagic

      Unfortunately, there are errors that SQL*Plus will return a zero no matter what you do. Then, your script that is running SQL*Plus needs to handle them. So, yes, it can be done; however, in most cases, it is a kluge to avoid writting a program that can do the same work, but only better.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (5)
As of 2024-04-23 18:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found