On 2010-09-23 00:02, John W. Krahn wrote:
s/^\s+//, s/\s+$// for $option, $sourceID, $targetID;
Variant:
s/\s+\Z//,
s/\A\s+//,
for $option,
$sourceID,
$targetID;
(I like to remove the trailing whitespace first.)
--
Ruud
--
To unsubscribe, e-mail: beginners-uns
Hi,
Thanks a lot for posting hte most efficient way to remove leading
and trailing spaces. And yes you are right the retval will always be zero. I
am guessing it was supposed to capture sql code errors but it wont. It will
capture only sqlplus errors.
I havent pasted the whole pl
HI,
1. I believe the -S option is to suppress thingls like the SQL*Plus
banner, and other output which doesnt need to be logged.
2. I wanted the sql commands in the same file to reduce the number
of script files.
Eventhough design wise it may not be perfect, the sqlplus commands
[ Please do not top-post. TIA ]
Gopal Karunakar wrote:
Hi,
Hello,
Here's the code pasted below. The sub basically executed an anonymous
pl/sql block (which is executing fine). I want to make sure that the user
will not be able to a ctrl-c and exit at the stage where the sql statements
On Sep 22, 11:04 am, gk.kalipuray...@gmail.com (Gopal Karunakar)
wrote:
> Hi,
>
> Here's the code pasted below. The sub basically executed an anonymous
> pl/sql block (which is executing fine). I want to make sure that the user
> will not be able to a ctrl-c and exit at the stage where the sql s
$retval = `/$ENV{'ORACLE_HOME'}/bin/sqlplus -s $QUERY_STRING << EOF >>
One question out of curiosity. Actually 2 questions:
1. I am not sure if -s is a valid sqlplus option. I have always used -S to
operate in silent mode. I am using SQL*Plus: Release 10.2.0.4.0 - Production
2. Is there any
Hi,
Here's the code pasted below. The sub basically executed an anonymous
pl/sql block (which is executing fine). I want to make sure that the user
will not be able to a ctrl-c and exit at the stage where the sql statements
are getting executed.
I tried declaring it as local but even then i
On Sep 22, 6:53 am, gk.kalipuray...@gmail.com (Gopal Karunakar) wrote:
> I used the $SIG{'INT'} = 'IGNORE'; in a sub in my script so that the
> script while executing the particular sub will ignore the ctrl-c. And I gave
> $SIG{'INT'} = 'DEFAULT'; at the end of the sub to reset the behavio
Hi All,
I used the $SIG{'INT'} = 'IGNORE'; in a sub in my script so that the
script while executing the particular sub will ignore the ctrl-c. And I gave
$SIG{'INT'} = 'DEFAULT'; at the end of the sub to reset the behavior back to
normal. But when i give the ctrl-c the process seems to be
