Hi

I have a control block where in i have placed two text items and a save button.When i enter data into those two text items the actual database shoud be updated when i press the save button.My update
statement is like this
declare
v_user_class1 order.user_class%type;
v_order_id order.order_id%type
begin

update order set :control.carrier = v_user_class1 where
order_id = v_order_id;
end;

It gives me an error saying
Encountered the symbol " " when expecting one of following
at line 10.
please help me out.I have to show it tommortrow.
It will be a great help