From: no.spam@please.com   
      
   Jan Bols wrote:   
      
   > 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   
   >   
      
   Not really any help, but I don't think the problem is the trim-function.   
   Your example works fine on my database. I'm running 9.2.0.1 on Windows   
   though.   
      
   Michael   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)