Hi everyone,
a question about a processing issue.
I have a form in which I manually type an ID value in a text field 1. If the text field 1 is null, the system should insert the primary key value (which is not yet generated) into a text field 2 after "create" button is pressed.
I tried to create a PL/SQL process before automated row processing, like:
begin
:P11_text_field_2 := P11_page_id;
end;
conditioning the process if the text field 1 is null. It works nice if I pick any other non-null field I inserted, but not with the primary key.
Ofc I cannot insert a value before it is generated, can you please suggest me how to solve this issue?
Many thanks
K