cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

Create triggers for Oracle databases using Thingworx

Huaxu
8-Gravel

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

Huaxu_0-1727602334277.png

An exception message is displayed after the command is executed

Huaxu_1-1727602369347.png

How can I resolve this exception

2 REPLIES 2
VladimirRosu
19-Tanzanite
(To:Huaxu)

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

Rocko
17-Peridot
(To:Huaxu)

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

 

Announcements


Top Tags