variable in a cursor

I declare a cursor as follows:

CURSOR GETMACHINES IS
  SELECT DISTINCT MACH
  FROM WAFER.PLATE_INFO
  WHERE
(FAC IS NOT NULL) AND
(MACH_DATA = "somevalue");

The problem is I don't know what the "somevalue" value is until later in the sql block. Is there a way I can setup this cursor to accept a value that I will pass into it later?

Thanks,
Mike

Sent via Deja.com
http://www.deja.com/ Received on Mon Feb 05 2001 - 17:27:42 CST