Call Stored Procedure From Forms Personalization

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

1. Personalize the form
2. Create an action of type "BuiltIn"
3. BuiltIn Type for Action should be "Execute a Procedure"

4. Argument should be as below 


='declare
   v_param_value VARCHAR2(200) ;
   begin
       test_pakage.yourprocedure;
  end'

Note: don't put semicolon after end.

You can pass field values as 
'''||${item.BLOCKNAME.FIELDNAME.value}||'''

Hope this helpful