validation engine to perform any validation at runtime

Question

Currently oracle apex is providing validation to create at any level with any operator , However my requirement is to define the validation at user level , like user should be able to set any validation criteria at any level on front end which will work same as oracle apex validation , expecting table structure with respect to validation definitions at user level or any other idea where we can use the same apex validation engine on front end.

Answer 1

There's possibly a few ways you could tackle this, depending on the types of validations you want to perform, and how much flexibility you can provide the users.

There are functions made available within the apex_plugin_util API that could help your cause. eg:

select apex_plugin_util.get_plsql_expression_result  ('1+2') sm
 ,apex_plugin_util.get_plsql_expression_result  (':app_id') bv
 ,apex_plugin_util.get_plsql_expression_result  (q'~case when 1=2 then 'T' else 'F' end~') cse 
from dual;

SM    BV    CSE  
----- ----- -----
3     105   F