Execute a Procedure within Form-Personalization

Hi everyone,

I'm trying to add the below SQL to a form-personalization I'm working on, but I keep getting an error message:

='DECLARE

BEGIN

FOR I in (SELECT line_id FROM oe_order_lines_all WHERE header_id = ''||${item.SCH_SUMMARY.HEADER_ID.value}||'')

LOOP

   UPDATE oe_order_lines_all

   SET attribute8 = ''1982''

   WHERE line_id = ''||${item.SCH_SUMMARY.LINE_ID.value}||'';

END LOOP;

COMMIT;

END'

Please advise what I missed?

Thanks,

Tom.