4.5.2 Working with Column Data Values

When your SQL or PL/SQL processes rows for an Interactive Grid, in addition to page and application items you can also reference a column value in the current row using a :COLUMNAME bind variable.

This includes grid-related usages like:

• validations for a grid column
• page processes with their Editable Region property set to a grid, and
• dynamic actions of type Execute Server-side Code reacting to grid column value change.

In the dynamic action case, remember to mention the column names you're referencing in the Items to Submit and Items to Return properties. Those values are a comma-separated list of one or more column names without the preceding colon in the name.

In the page processing use case for new or modified grid rows, in addition to being able to change the value of a page item or application item, you can use a bind variable to set the value of a column by assigning an expression to a :COLUMNNAME bind variable using := as shown below:

-- Change clerk to analyst in current grid row being processed
IF :JOB = 'CLERK' THEN
   :JOB := 'ANALYST';
END IF;