trim(' ') problem & ORA-03113

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 - 13:05:16 CEST