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

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

I want to save data in oracle

KANGJAEHYUCK
6-Contributor

I want to save data in oracle

question1.PNGquestion2.PNG

question3.PNG

 

I saw this manual.

https://developer.thingworx.com/en/resources/guides/external-databases/external-database-write

but Invalid column index Error confirmed. 

 

I used two methods.

SQL (Command), SQL (Query)

 

And I used three methods.

([[ipvalue]], [[clocksvalue]], [[tempervalue]], [[loadvalue]], [[powervalue]], SYSDATE);
('[[ipvalue]]', '[[clocksvalue]]', '[[tempervalue]]', '[[loadvalue]]', '[[powervalue]]', SYSDATE);
('<<ipvalue>>', '<<clocksvalue>>', '<<tempervalue>>', '<<loadvalue>>', '<<powervalue>>', SYSDATE);

 

The inputs data are all strings.

 

Configuration is not wrong.

I think my method is wrong.
Can you help me?

1 ACCEPTED SOLUTION

Accepted Solutions

hi.

Thank you for your reply.

The problem has been solved.

I put it in SQL(Command).

and

I've used the following methods:

INSERT INTO kjhTemperTest(IP, CPUCLOCKS, CPUTEMPER, CPULOAD, CPUPOWERS, CURDATES)
VALUES([[ipvalue]], [[clocksvalue]], [[tempervalue]], [[loadvalue]], [[powervalue]], SYSDATE)

 

And then I removed the annotation.

The annotation was bad.

 

View solution in original post

2 REPLIES 2

Hi,

 

Second service is correct, PracticeInsert, always an insert should be put in a SQL(Command).

Have you provided values for all the parameters? Try without "<< >>".

In the Application.log of Thingworx what error do you see? Can you please translate in English the SQL Exception?

 

Thank you,

Raluca Edu

hi.

Thank you for your reply.

The problem has been solved.

I put it in SQL(Command).

and

I've used the following methods:

INSERT INTO kjhTemperTest(IP, CPUCLOCKS, CPUTEMPER, CPULOAD, CPUPOWERS, CURDATES)
VALUES([[ipvalue]], [[clocksvalue]], [[tempervalue]], [[loadvalue]], [[powervalue]], SYSDATE)

 

And then I removed the annotation.

The annotation was bad.

 

Top Tags