3 Replies Latest reply: Jul 15, 2013 8:39 AM by 996325 RSS

    How to use a bind variable in a table-validated flexfield

    996325

      I want to prepare a table-validated descriptive flexfield, which uses as source a select statement.

       

      So, in the form "Validation table information" I use as table name the statement:

       

       

       

      (SELECT my_procedure('test_value') FROM DUAL)

       

       

       

      Up to here it works fine.

       

      But instead of 'test_value' I want to use the value of a field in the form or a value of another flex (using $FLEX$ bind variables).

       

       

       

      Please advice if it is possible to perform this in "table name" statement. I use it in "where/order by" clauses and it works fine.

       

       

       

      Thank you.