user995809 wrote:Try redirecting to error page when validation fails. (means edit the validation and chose Error message display location as Error Page)
I've a report region query-
select distinct col1, col2,
When 'Y' (valid) selected from the select list and SUBMIT is clicked - a validation and then page processing pl/sql process will run for the record, branching to the same page.
If validation fails custom error message comes on screen, but value of column "Action" is reset to default 'No_Action'.
Can anyone please tell me how can I show the last selected value in column "Action"?
Please reply asap. Regards.
COL_YN is the column where you stored the last selection. Unless you store it in some table/column you cannot get it back into the report when it is refreshed.
select distinct col1, col2, APEX_ITEM.HIDDEN(2,col3)|| APEX_ITEM.SELECT_LIST(1,NVL(COL_YN,'N'),'Valid;Y,Invalid;N') Action from <tab1>