in reply to invoking Oracle's SQL Plus, return code always indicates success

If you need to use SQL*Plus (instead of DBI), you'll want a WHENEVER SQLERROR statement in the file.

Caution: Contents may have been coded under pressure.
  • Comment on Re: invoking Oracle's SQL Plus, return code always indicates success

Replies are listed 'Best First'.
Re^2: invoking Oracle's SQL Plus, return code always indicates success
by chuckster (Initiate) on Apr 06, 2005 at 23:11 UTC
    Thanks. That sounds like it'll work. We're avoiding DBI at this time, as we just need simple scripts which our Scheduling Tool can execute. Am I allowed to give you points towards PerlMonkdom, or can only others do that? I can't figure out how yet, but I will if you give me the URL which describes the process.
      Unless you absolutely need to, use a shell script for this task instead of Perl. Or, spend the time to build an infrastructure in Perl that will stand you in good stead. I worked on scheduling tools (Control-M primarily, though some Tivoli and SQL*Server Scheduler) for 6 months on a contract and that's what we ended up doing. Devoted a month to it and did a year's worth of work every month after that. That's not counting the work we didn't even think was possible that was now a piece of cake.
      You gain the ability to upvote and downvote posts after you yourself have gained some experience points. See Levels of Monks for what awaits you if you devote yourself to the monastery.

      Caution: Contents may have been coded under pressure.