"The specified procedure could not be found."

user8820809

I'm getting the following trying to run an app using oracledb.

C:\src\stash\calculations-viewer>node server/index.js
C:\src\stash\calculations-viewer\node_modules\oracledb\lib\oracledb.js:28
    throw err;
    ^


Error: The specified procedure could not be found.
\\?\C:\src\stash\calculations-viewer\node_modules\oracledb\build\Release\oracledb.node
    at Error (native)
    at Object.Module._extensions..node (module.js:450:18)
    at Module.load (module.js:356:32)
    at Function.Module._load (module.js:313:12)
    at Module.require (module.js:366:17)
    at require (module.js:385:17)
    at Object.<anonymous> (C:\src\stash\calculations-viewer\node_modules\oracledb\lib\oracledb.js:23:15)
    at Module._compile (module.js:425:26)
    at Object.Module._extensions..js (module.js:432:10)
    at Module.load (module.js:356:32)

"oracledb.node" exists in the location mentioned in the error message.  The module builds fine, and the paths to OCI includes and libs also seem fine. 

Here are my paths, I've triple-checked they exist.

OCI_INC_DIR=C:\oracle\instantclient_12_1\sdk\include
OCI_LIB_DIR=C:\oracle\instantclient_12_1\sdk\lib\msvc

I must be missing something, but I just can't see what.

Any ideas?

Thanks

Glenn

user8820809

Oh dear.  I cleaned my PATH last week and must have inadvertently removed the oci.dll from it.

[bangs head on desk]

user8820809

Oh dear.  I cleaned my PATH last week and must have inadvertently removed the oci.dll from it.

[bangs head on desk]

Christopher Jones-Oracle

Having PATH set would help...

Don't forget OCI_INC_DIR and OCI_LIB_DIR are only needed during installation.

3427902

I am having a similar issue. Can you elaborate  on oci.dll  ?