Re: trim(' ') problem & ORA-03113
From: Chris Hunt <chris_at_extracon.com>
Date: 16 Oct 2003 03:20:49 -0700
Message-ID: <4fb74c0e.0310160220.385e90c9_at_posting.google.com>
Date: 16 Oct 2003 03:20:49 -0700
Message-ID: <4fb74c0e.0310160220.385e90c9_at_posting.google.com>
Jan Bols <jan_at_ivpv.ugent.be> wrote in message news:<bkemli$pg6$1_at_gaudi2.UGent.be>...
> Whenever I execute TRIM(' ')in a stored procedure or trigger, I get an
> ORA-03113 error.
I've just run into the same bug - on an 8.1.6.3.0 database. It'll let you
SELECT TRIM(' ') FROM dual;
but crashes out if you
DECLARE
x VARCHAR2(10);
BEGIN
x := TRIM(x);
END;
Fortunately there's an easy workaround, you just go back to how we
used to do it before TRIM() was invented...
x := LTRIM(RTRIM(x));
That seems to work without any problems.
- Chris Hunt http://www.extracon.com