node-oracle | node.js driver to connect with an oracle database | Database library

I fixed this problem like this:

first of all , you have to install node-oracledb from source code. it has to be like this(it depends on your oracledb version)

From the node-oracledb 5.0 changelog:

Webpack users should copy the node-oracledb binary into a sub-directory of the output directory. For example if the output directory is dist, then the binary should be in dist/node_modules/oracledb/build/Release/oracledb-5.0.0-linux-x64.node. A copy plugin in webpack.config.js can do this by copying node_modules/oracledb/build to a directory of that same name. See Issue 1156.

A potential thing to review is the use of ES modules - I have not tried them in this context.

Thank you, Christopher Jones and saiharika213. Posting your suggestions as an answer to help other community members.

This ORA-28759: failure to open file error seems you need to update the WALLET_LOCATION directory in sqlnet.ora. You can refer to Connecting to Oracle Cloud Autonomous Databases

You can resolve this error by changing the connection string to point to the wallet location. Move the wallets to respective project folder and modify the connection string as below in dbConfig.js. Provide the wallet path from root till wallet folder.

For example:

If there is an error getting the connection, your catch block calls conn.close() without having a valid conn. This gives the error you see. It may not be the only cause, but tidying the code will help.

Your conn.close() could be just once in a finally() block. Look at examples like example.js e.g. like:

• You are passing the string execute ... to the database. But execute is not a SQL keyword - it is a SQL*Plus command. So the database doesn't understand it and gives an error. Instead do begin viewSystemUsers() end;.

• For ease of programming use async/await, not callbacks

• Review the node-oracledb example impres.js becuase this shows the use of Implicit Results (which is what dbms_sql.return_result() is).

• Review the node-oracledb example plsqlproc.js.

You code could be like:

Follow the instructions found in the documentation located here: https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html.

So long as cx_Oracle is installed in the Python used by PyCharm you should be able to see it.

Use string concatenation:

There are some notes in the node-oracledb pool example...

Look at the node-oracledb examples https://github.com/oracle/node-oracledb/blob/master/examples/plsqlfunc.js and https://github.com/oracle/node-oracledb/blob/master/examples/plsqlrecord.js

Also review the node-oracledb documentation.

To start with you need to use another bind variable to return the function result to. The trick is setting the type - I don't know what INFO_ITEM is. Something like this might work: