When the items are DISPLAY ONLY do you have the "Save Session State" setting set to "Yes"?
What is the Process when the "Create" button is clicked?
I usually call a procedure that adds records.
code_schema.my_app_api.addComment( :P2_PAT_ID, :P2_COMMENTS );
Since the end-user is not allowed to edit demographics information, you don't need to send that.
The procedure will re-fetch all that information, most likely, as part of an 'INSERT ... SELECT' statement.
In your dynamic action, add an exception "when no_data_found" clause to clear out the values... (and set ID to NOT FOUND)
EXCEPTION WHEN no_data_found THEN P2_PAT_ID := 'Pat ID not found'; -- I'm sure there is a cheat for this. P2_FIRST_NM := NULL; P2_LAST_NM := NULL; P2_DOB := NULL; END;
I have the "Save Session State" set to "No"
When the create button is clicked it uses the DML process to insert the record. I don't have a procedure to do the insert.
Additionally i want to show(display) the end user the patient demographics before they create the record.
And the only thing i really want to send or submit is the patient id which is displayed.