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@ivpv.ugent.bewrote in message news:<bkemli$pg6$1@gaudi2.UGent.be>...
Quote:
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
>
SQLselect 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
