Create triggers for Oracle databases using Thingworx

[Huaxu]

I tried to create an Oracle database trigger using Thingworx,Database connection successful.

I created a command service

An exception message is displayed after the command is executed

How can I resolve this exception

[VladimirRosu]

Is the same command executing successfully if you run it in Oracle SQL Developer (or whatever equivalent of it you might use) ?

[Rocko · Accepted solution]

Try to use the <<>> notation instead of [[]] for the parameters. (see https://www.ptc.com/en/support/article/CS355016)

If all else fails. concat the string and use execute immediate, similar to Example 3 here: https://www.ptc.com/en/support/article/CS261346