Question

Application Server Task

  • 25 June 2023
  • 1 reply
  • 69 views

Userlevel 2
Badge +3
  • Do Gooder (Customer)
  • 1 reply

Hello

How to execute Schedule Database Task in custom event.

Thanks.


1 reply

Userlevel 5
Badge +9

Hi @tariq 

You can use below structure in an online SQL type action.

Please note that this a example and please update the variables accordingly and refer to Deferred_Call method to understand all the parameters.

DECLARE
attr1_ VARCHAR2(32000);

BEGIN

Client_SYS.Clear_Attr(attr1_);
Client_SYS.Add_To_Attr('ORDER_NO','&NEW:ORDER_NO',attr1_);
Client_SYS.Add_To_Attr('NEW_REASON','&NEW:BLOCKED_REASON',attr1_);
Client_SYS.Add_To_Attr('OLD_REASON','&OLD:BLOCKED_REASON',attr1_);
Transaction_SYS.Deferred_Call('TEST_API.Update_customer_order',attr1_,description_);
END; 


 

Reply