I like this solution. It works way better than the
dbms_lock.sleep() suggestion ;)
Thank you.
Saira
-Original Message-
Sent: November 6, 2003 3:54 PM
To: [EMAIL PROTECTED]
Cc: Saira Somani-Mendelin
Catch the error in an exception clause and ignore it.
SQL set
Don't tell me you tried it g
MG, another feather for your Cap ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having
The sleeping beauty suggestion works extremely well, if you are patient.
Patience, you know, is a virtue and my goal is to promote fair and balanced
view to the database.
On 11/07/2003 09:17:12 AM, Saira Somani-Mendelin wrote:
I like this solution. It works way better than the
Mladen Gogala scribbled on the wall in glitter crayon:
The sleeping beauty suggestion works extremely well, if you are
patient. Patience, you know, is a virtue and my goal is to promote
fair and balanced view to the database.
me, i want my patience RIGHT NOW!;-)
BTW, is there any chance of
Hee hee... I am indeed a novice, but I make fairly sound judgments based
on the name of a function :)
-Original Message-
Jamadagni, Rajendra
Sent: November 7, 2003 9:30 AM
To: Multiple recipients of list ORACLE-L
Don't tell me you tried it g
MG, another feather for your Cap ...
I'm sure there are many ways to perform complex validations a shell
script. And I needed a simple solution so I opted for the easy way.
Unfortunately, I'm not an expert shell programmer yet. Fortunately, I
did receive many good suggestions from the list to help me progress in
my quest to learn
Catch the error in an exception clause and ignore it.
SQL set serveroutput on
SQL run
1 declare
2 x number ;
3 begin
4 x := to_number ('123^') ;
5 exception
6 when value_error
7 then
8dbms_output.put_line ('Bad Number') ;
9 when others
10 then
If you're familiar with Perl and DBI, that would be a good solution.
You can quite easily hide errors that way.
Jared
Saira Somani-Mendelin [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2003 12:44 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
Saira,
How about use the same method as suggested in another thread, i.e. pipe and
remove unwanted text? In your case
whatever comes in | sed -n '/^BEGIN/,/^ORA-06512: at line/!p'
Yong Huang
--- Saira Somani-Mendelin [EMAIL PROTECTED] wrote:
List,
I have a shell script that executes a
You might be inclined to try something like:
DECLARE
...
BEGIN
.
EXCEPTION
WHEN INVALID_NUMBER THEN
DBMS_LOCK.SLEEP(365*24*3600);
END;
/
On 11/06/2003 03:44:26 PM, Saira Somani-Mendelin wrote:
List,
I have a shell script that executes a sql*plus script (which executes a
See the Code below. It worked fine for me.
Probably you have a raise_exception_error somewhere in the procedure.
SQL create procedure RELEASE_PO_B_H ( in_number varchar2 ) is
2v_number number;
3 begin
4v_number := in_number;
5 exception
6when value_error then
7
most appropriate way is to use a
begin
..
exception
when invalid_number then
dbms_output.put_line('Sorry, a batch number must be numeric, please try again.');
when ...
..
end
Raj
Rajendra dot
=)
Why not do
whenever sqlerror exit 1
Bambi.
-Original Message-
Sent: Thursday, November 06, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L
You might be inclined to try something like:
DECLARE
...
BEGIN
.
EXCEPTION
WHEN INVALID_NUMBER THEN
If the data is supposed to be strictly numeric, you can intercept the bad
data prior to running the sql.
X=''
while [ -z $X ]; do
echo
echo Enter a number or Q to quit
read X
if [ $X = Q ]; then
echo Exiting ...
exit 0
fi
14 matches
Mail list logo