Query Executes Quickly in SQL Developer but Extremely Slow via Node.js oracledb

[Suryamaheshd]

Issue Description

We are experiencing a significant performance difference when running the same Oracle SQL query through different clients:

• In Oracle SQL Developer: The query executes in 5–10 seconds
• In Node.js using the oracledb package: The same query takes over 10 minutes

---

Test Details

• Database: Oracle

• Client Library: Oracle Instant Client

• Node.js Package: oracledb

• Node.js Version: v22.19.0

• oracledb Version: 19.28.0

• Instant Client Versions Tried: 21 and 19

• Query:

  SELECT * FROM TABLE (XXALG_TABLE_22A_PKG.GET_LOC_TBL_TYPE_F(:P_ORG_ID, :P_LAST_REFRESH));

[sharadraju]

What is the node-oracledb version that you are using?
Have you tried using node-oracledb Thin mode?

[Suryamaheshd]

node-oracledb ^6.7.0
No I am using thick mode only
when I am trying with thin mode I am facing an error NJS-116: password verifier type 0x939 is not supported by node-oracledb in Thin mode