Re: trim(' ') problem & ORA-03113

Your code worked on my 8173 Oracle db too. Maybe your sqlplus session had some problem. Try to open another new sqlplus session and see if it solves your problem.

HTH. Guang

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 have an oracle db 8.1.7.0.1 Enterprise edition installed on a
> linux-Mandrake 9.1.
>
> EXEMPLE:
> I created the function IS_NULL which returns 1 or 0 if the parameter is
> empty or not:
>
> CREATE OR REPLACE FUNCTION IS_NULL(v VARCHAR2)
> RETURN NUMBER
> IS
> BEGIN
> IF TRIM(v) IS NULL THEN
> RETURN 1;
> ELSE
> RETURN 1;
> END IF;
> END;
>
>
> When excuting the following sql I get an ORA-03113 error
>
> SQL> select is_null(' ') from dual;
> select is_null(' ') from dual
> *
> ERROR at line 1:
> ORA-03113: end-of-file on communication channel
>
>
> What's wrong with TRIM(' ') and how else can I check if a variable
> consists of empty spaces without using TRIM?
>
> Jan Bols
Received on Fri Sep 19 2003 - 21:16:48 CEST