# How to use Oracle DB Node?

**URL:** https://discourse.nodered.org/t/how-to-use-oracle-db-node/28005
**Category:** Dashboard
**Created:** [8 June 2020 17:48 UTC](https://discourse.nodered.org/t/how-to-use-oracle-db-node/28005 "2020-06-08T17:48:50Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![RyuunosukeDS3](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ryuunosukeds3/32/22503_2.png) [@RyuunosukeDS3](https://discourse.nodered.org/u/RyuunosukeDS3)
#### Post date: [8 June 2020 17:48 UTC](https://discourse.nodered.org/t/how-to-use-oracle-db-node/28005/1 "2020-06-08T17:48:50Z")

</div>

Hello Fellows! I've been trying to connect to an oracle db but I aways get "Oracle query error: ORA-01036: illegal variable name/number" (Won't share the flow for security reasons) the query i'm currently trying:  
`SELECT * FROM VW_DT_PROD_EQUIP_SAFRAS_v2`  
First time trying to use oracle db, and i feel like i'm missing something...

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)
#### Post date: [8 July 2020 17:48 UTC](https://discourse.nodered.org/t/how-to-use-oracle-db-node/28005/2 "2020-07-08T17:48:52Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.