Create triggers for Oracle databases using Thingworx

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

RockoAnswer

19-Tanzanite

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

19-Tanzanite

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

Translate

Answer

19-Tanzanite

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

Translate

2 replies