# How to install previous version of node-red-contrib-oracledb-mod

**URL:** <https://discourse.nodered.org/t/how-to-install-previous-version-of-node-red-contrib-oracledb-mod/16587>\
**Category:** General\
**Created:** [11 October 2019 05:28 UTC](https://discourse.nodered.org/t/how-to-install-previous-version-of-node-red-contrib-oracledb-mod/16587 "2019-10-11T05:28:55Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Divya](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/divya/32/6208_2.png) [@Divya](https://discourse.nodered.org/u/Divya)\
**Post date:** [11 October 2019 05:28 UTC](https://discourse.nodered.org/t/how-to-install-previous-version-of-node-red-contrib-oracledb-mod/16587/1 "2019-10-11T05:28:55Z")

</div>

Hello everyone,  
I was using the previous version of node-red-contrib-oracledb-mod (v0.5.4). Restarted the node-red and the flows were no more deployed as it contained the older version of node-red-contrib-oracledb-mod and it was updated a week ago. I installed this latest version and my queries are not running now.

I am getting the following error  
Oracle query error: ORA-01036: illegal variable name/number

Please help me out in resolving this issue. Thanks

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [11 October 2019 05:41 UTC](https://discourse.nodered.org/t/how-to-install-previous-version-of-node-red-contrib-oracledb-mod/16587/2 "2019-10-11T05:41:05Z")

</div>

You can install any version you like on the command line using npm by using `@versionnumberyouwanttoinstall` after the node name

---

<div class="post-metadata">

**Author:** ![Divya](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/divya/32/6208_2.png) [@Divya](https://discourse.nodered.org/u/Divya)\
**Post date:** [11 October 2019 05:41 UTC](https://discourse.nodered.org/t/how-to-install-previous-version-of-node-red-contrib-oracledb-mod/16587/3 "2019-10-11T05:41:59Z")

</div>

I tried that. But, it says no matching version.

---

<div class="post-metadata">

**Author:** ![Divya](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/divya/32/6208_2.png) [@Divya](https://discourse.nodered.org/u/Divya)\
**Post date:** [11 October 2019 05:58 UTC](https://discourse.nodered.org/t/how-to-install-previous-version-of-node-red-contrib-oracledb-mod/16587/4 "2019-10-11T05:58:12Z")

</div>

Yeah it worked fine for me now. Earlier, I typed a wrong command by mistake.

Thanks @ukmoose, it was of a great help.

Is there any way to install the previous version from the Manage Palette directly instead of doing it in the command line.

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [11 October 2019 06:56 UTC](https://discourse.nodered.org/t/how-to-install-previous-version-of-node-red-contrib-oracledb-mod/16587/5 "2019-10-11T06:56:12Z")

</div>

> [@Divya](#):
>
> Is there any way to install the previous version from the Manage Palette

No there isn’t

---

<div class="post-metadata">

**Author:** ![Divya](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/divya/32/6208_2.png) [@Divya](https://discourse.nodered.org/u/Divya)\
**Post date:** [11 October 2019 13:18 UTC](https://discourse.nodered.org/t/how-to-install-previous-version-of-node-red-contrib-oracledb-mod/16587/6 "2019-10-11T13:18:26Z")

</div>

Ok. Thanks for the guidance. That node got installed and working fine for me. Tried in command line only.