You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!