Hi,
We created a text field item(P1_COMMENTS) in oracle APEX page. This item create at page level only. this is neither a database field nor a table column.
When user submit the button execute the PL/SQL Procedure through dynamic action process.
This PL/SQL procedure has one input parameter. The above text field value mapped to PL/SQL procedure input parameter with bind variable (:P1_COMMENTS). After click on submit button PL/SQL procedure executed with out any errors. However, The text filed item value passing null instead of user enter value.
I test the procedure input parameter with hardcode value. it's working. Parameter taken this Hardcode value and procedure executed after click on submit button.
BEGIN
XXX_APPROVE_REQUEST.ACTION(P_COMMENTS=>:P1_COMMENTS);
END;
Please help me to solve this.