Agent action error Stored procedure calls within DIRECT SQL Update are not enabled
Hi Team,
OTM cloud instance version is 24c- 24.3.1-20240830
We don't have any stored procedure at the moment (used to have it in this project before migrating to cloud). The DSU agent action is of statement type Plain SQL statement wherein we are trying to insert a shipment remark from an order remark.
It is a simple insert statement with operator nextval in it like below
insert_into shipment_remark (shipment_gid,REMARK_SEQUENCE,REMARK_QUAL_GID,REMARK_TEXT,DOMAIN_NAME)
(select $gid,remark_sequence.nextval,'XYZ.xy',orm.remark_text,'XYZ' from order_release_remark orm, order_movement om, shipment s where s.shipment_gid = om.shipment_gid and om.order_release_gid = orm.order_release_gid and s.shipment_gid = $gid and orm.remark_qual_gid='XYZ.xy')
0