Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X
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
Is the same command executing successfully if you run it in Oracle SQL Developer (or whatever equivalent of it you might use) ?
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