Re: Trapping error inside stored procedure using ON EXCEPTION

Posted in 1995

Roger Tomas — 25 Nov 1995 14:45:41 GMT — source: Informix-list mailing list archive (1991-1998)

vsp@triada.triad.com (Vaishali Padhye) wrote: >Can someone tell me whats wrong with this procedure? It does'nt >work and it won't recognize NULL in my IF statements! > > IF name = NULL THEN > LET num = NULL; > ELSE I'm a 5.01 user so I didn't even bother to look at the dbinfo stuff. But, the IF statement should be: IF name IS NULL THEN Roger Tomas AG Communication Systems