Calling Stored procedure through Forms Personalization
2. Create an action of type “BuiltIn”
3. BuiltIn Type for Action should be “Execute a Procedure”
v_field_value VARCHAR2(200) ;
begin
plsql_package.procedurenameHere ;
end’
v_field_value VARCHAR2(200) ;
begin
XX_PRC(”’||${item.PO_CONTROL_RULES.OBJECT_CODE_DISPLAYED_VALUE.value}||”’);
end’
Also, there is no semi colon after “end”
”’||${item.BLOCKNAME.FIELDNAME.value}||”’
Leave a Reply
Want to join the discussion?Feel free to contribute!