NEED ORACLE SQL FORMS HELP!!!

Hi, I am trying to test to see if a value from a field in sql forms3.0 is in a table and if so then do some statements. I have set up an if statement to do it, but it gives me a "subquery not allowed in this context." error message.

here is the code I tried:

IF :block_name.field_name IN (SELECT column_name FROM table) THEN statements;
statements;
END IF; I was thinking of trying to bring each value from the table into a variable then test to see if they are equal by using a loop. Will this work, or is there a better way (examples would be appreciated.)

thanks,

Matthew

--
  *     *   informatik . Struktur . Vektor RE:Search | "With your eyes open-
   *  *                                              |  you know soft spoken
    *         cyber-therial / industrial immersion   |  changes nothing,
  *  *                                               |  a view so cruel."
*     *     .info/contakt zone: crofoot_at_csa.bu.edu   |       -Skinny Puppy