Call a pl/sql API from forms personalization

To call a pl/sql API from forms personalization, do this

• Personalize the form
• Create an action of type "BuiltIn"
• BuiltIn Type for Action should be "Execute a Procedure"
• Argument should be as below

='declare
v_field_value VARCHAR2(200) ;
begin
xx_proc ('''||${item.BLOCKNAME.FIELDNAME.value}||''');
end'

Note the syntax, after =, entire declare begin end is within single quote. Also, there is no semi colon after "end"

You can pass field values as

'''||${item.BLOCKNAME.FIELDNAME.value}||'''