# Error: SQLSyntaxErrorException: ORA-00900

**URL:** <https://forum.inductiveautomation.com/t/error-sqlsyntaxerrorexception-ora-00900/19576>\
**Category:** General Discussion\
**Tags:** database, scripting\
**Created:** [September 7, 2018, 8:35am UTC](https://forum.inductiveautomation.com/t/error-sqlsyntaxerrorexception-ora-00900/19576 "2018-09-07T08:35:20Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mohamed.moussa-iman](https://avatars.discourse-cdn.com/v4/letter/m/c68b51/32.png) [@mohamed.moussa-iman](https://forum.inductiveautomation.com/u/mohamed.moussa-iman)\
**Post date:** [September 7, 2018, 8:35am UTC](https://forum.inductiveautomation.com/t/error-sqlsyntaxerrorexception-ora-00900/19576/1 "2018-09-07T08:35:20Z")

</div>

Hello,

In a script i’m trying to run this request:  
system.db.runQuery(“INSERT INTO IMPLANTPVA (REFIMPLANTPVA, NAMEEN, NAMEFR) VALUES (” + str(int(primer\_key)) + “, '” + pva\_name + “’, '” + pva\_name + “’)”)

The line is inserted in the table but i also have this error: SQLSyntaxErrorException: ORA-00900: invalid SQL statement.

Someone can help me please

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [September 7, 2018, 10:52am UTC](https://forum.inductiveautomation.com/t/error-sqlsyntaxerrorexception-ora-00900/19576/2 "2018-09-07T10:52:11Z")

</div>

At a quick glance, it appears you are missing a single quote at the beginning of your values

---

<div class="post-metadata">

**Author:** ![mohamed.moussa-iman](https://avatars.discourse-cdn.com/v4/letter/m/c68b51/32.png) [@mohamed.moussa-iman](https://forum.inductiveautomation.com/u/mohamed.moussa-iman)\
**Post date:** [September 7, 2018, 11:19am UTC](https://forum.inductiveautomation.com/t/error-sqlsyntaxerrorexception-ora-00900/19576/3 "2018-09-07T11:19:08Z")

</div>

Thank you for your answer but i don’t really see where i’m missing a quote and even with a simple query like:  
system.db.runQuery(“INSERT INTO table (col1, col2, col3) VALUES (1, ‘hello’, ‘world’)”), i have the same error.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [September 7, 2018, 11:41am UTC](https://forum.inductiveautomation.com/t/error-sqlsyntaxerrorexception-ora-00900/19576/4 "2018-09-07T11:41:47Z")

</div>

Sorry, I should have taken a closer look 🙂

For inserts, you need to use _system.db.runUpdateQuery()_

---

<div class="post-metadata">

**Author:** ![mohamed.moussa-iman](https://avatars.discourse-cdn.com/v4/letter/m/c68b51/32.png) [@mohamed.moussa-iman](https://forum.inductiveautomation.com/u/mohamed.moussa-iman)\
**Post date:** [September 7, 2018, 11:51am UTC](https://forum.inductiveautomation.com/t/error-sqlsyntaxerrorexception-ora-00900/19576/5 "2018-09-07T11:51:25Z")

</div>

it’s working Thank you so much