In Designer6i I have created a form that has an action item (button)
that when pressed calls the CANCEL procedure. The CANCEL procedure
changes the value of a database column (STATUS_CODE) from 'AUTHORIZED' to 'CANCELED'. What trigger can I use at the block level that will update the block on the form and display the new db STATUS_CODE value on the form?

I tried using POST-UPDATE with this code:

BEGIN
select status_code
into :blk_items.status_code
from items
where rowid = :blk_items.rowid;
END;

It did not requery the database and display the new values.

This is the code for my procedure:

CREATE OR REPLACE PROCEDURE cancel
(p_id IN planning_groups.id%type)
IS
BEGIN

UPDATE items
SET
items.status_code = 'CANCELED'
WHERE
items.pg_id = p_id
AND items.status_code = 'AUTHORIZED';

DBMS_OUTPUT.PUT_LINE
('Items with AUTHORIZED status were changed to CANCELLED.');

COMMIT;

EXCEPTION
WHEN NO_DATA_FOUND THEN
RAISE_APPLICATION_ERROR
(-20201, 'No data was found.');

END cancel;
/

Thanks in advance,
MH