From: jan@ivpv.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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)