Create triggers for Oracle databases using Thingworx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
-
Coding
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is the same command executing successfully if you run it in Oracle SQL Developer (or whatever equivalent of it you might use) ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
