Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: LIKE operator causes server crash
Hi,
You also have a
nvl(length(arg1),0)
How does SQL behave when arg1 is null?
(I don't have access right now...)
try
length(nvl(arg1,''))
This is iffy, but it is another place where arg1 might play a detrimental role.
Mike Stout Received on Fri Feb 19 1999 - 22:15:28 CST