# How do I use oracledb?

**URL:** <https://discourse.nodered.org/t/how-do-i-use-oracledb/28548>\
**Category:** General\
**Created:** [18 June 2020 11:54 UTC](https://discourse.nodered.org/t/how-do-i-use-oracledb/28548 "2020-06-18T11:54:11Z")\
**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:** [18 June 2020 11:54 UTC](https://discourse.nodered.org/t/how-do-i-use-oracledb/28548/1 "2020-06-18T11:54:12Z")

</div>

I've been trying to query from a oracle db using the node-red-contrib-oracledb-mod but it simply wont work.

Here is the query : `SELECT * FROM UPNIVEL2`

Field Mapping:  
`["location.of.first.array.index.field.in.msg.payload", "location.of.second.array.index.field", "last_array_indexfield.in[3]" ]`

but it outputs this:

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/9/f944f4b742c2c6f1698d2dbc621b114707d80650.png)

EDIT:  
it connected with no problems, btw.  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/0/20329714366757f9b8795f007fcdebba93cd8ec2.png)

---

<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:** [17 August 2020 11:54 UTC](https://discourse.nodered.org/t/how-do-i-use-oracledb/28548/2 "2020-08-17T11:54:23Z")

</div>

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