Re^2: invoking Oracle's SQL Plus, return code always indicates success

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.

Comment on Re^2: invoking Oracle's SQL Plus, return code always indicates success

Replies are listed 'Best First'.
Re^3: invoking Oracle's SQL Plus, return code always indicates success by dragonchild (Archbishop) on Apr 07, 2005 at 00:20 UTC
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. My wife's blog	[reply]
Re^3: invoking Oracle's SQL Plus, return code always indicates success by Roy Johnson (Monsignor) on Apr 07, 2005 at 03:21 UTC
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.	[reply]