At 11:51 AM 22/04/2005 +1000, Grant Brown wrote:

>Hi all,
>
>I am having a problem with a delete statement in a stored procedure.
>
> delete from D_LIST_HEAD
> where (DETECTID=:FIND_ID) or (DATATYPE=:CHECK_DT and INT001=:FIND_ID);
>
>It deletes the record where DETECTID=:FIND_ID
>
>but
>
>it does not delete records where (DATATYPE=:CHECK_DT and INT001=:FIND_ID)
>
>how do I re-write the where clause so that it can find both ?

The WHERE clause looks OK to me. Given that the value passed in for
FIND_ID seems to work, I'd be looking at the value the procedure is getting
or CHECK_DT.

./heLen