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

firtsly, I assume one of those is a "return 0;"

Secondly, you probably need a PRAGMA inside the function definition (not always needed in 9+ DBs). From memory it is RNDS, WNDS, RNPS WNPS. ETA 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 Tue Oct 14 2003 - 16:13:24 CEST