APEX

I have a form that I am using to collect parameters to pass to a stored function which creates a database record and returns the primary key of the new record into an item on my form. I then want to branch to a URL and pass the value in the item to the URL. I would like all of this to be accomplished with 1 button.

Here is what I have done so far.

I created an item (P1_REPORT_ID) to hold the return value.
I created a button that has a Button_Request_Value of RUN_REPORT.
I created a process
(PL/SQL annonomous block)
(Process Point-On Submit - After Computations and Validations)
(Conditional Processing - Request = Expression 1 - Expression 1 = RUN_REPORT)
which creates the record and returns the primary key into the item.


All of this works.

Now after the processing I want to branch to a URL and pass the value in P1_REPORT_ID to it, then clear out P1_REPORT_ID.

Any suggestions

Thanks