3 Replies Latest reply on Jul 15, 2013 1:52 PM by InoL

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


      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.