Execute a Procedure Using form personalization

Execute a Procedure Using form personalization

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_field_value VARCHAR2(200) ;

   begin

       plsql_package.procedurenameHere ;

  end'

or alternately

='declare

   v_field_value VARCHAR2(200) ;

   begin

       apassi_prc ('''||${item.PO_CONTROL_RULES.OBJECT_CODE_DISPLAYED_VALUE.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}||'''