Hello
How to execute Schedule Database Task in custom event.
Thanks.
Hello
How to execute Schedule Database Task in custom event.
Thanks.
Hi
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;
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.