HELP : Substitution SQL Parameters in Forms

[Quoted]     I want to know if there's a way of executing a SQL query in FORMS 4.5 with a substitution SQL parameter..

    for example:

        i've a text field in the current record that may contain the follow text : '5000,5545,5564'

        i want that when i push a button the follow SQL should be executed:
        select xxx into field_b
        from table
        where id IN '5000,5545,5564';   -- values in the text field

    So, i just want to replace the condition values in the query by the field values...

    If there's another way of doing it tell me... by forms, by a view or a function.. just mail ME please...

--

• Joao Ricardo B Oliveira jricardo_at_ipb.pt
  -
  
• Oracle DBA http://www.ipb.pt/~jricardo

  ---