joeferner / node-oracle

node.js driver to connect with an oracle database.

This library is not maintained.

The node-oracle driver is obsolete. Oracle has a new driver: node-oracledb.

Please install the new driver with 'npm install oracledb'. Instructions are here.

If you absolutely need the old driver, use 'npm install [email protected]'

node-oracle's Issues

Issue building on RHEL 6.2 with OCI 12.1.0.1.0

The build seems to be looking for lzzn(oci_version), and it doesn't seem to be installed by the Oracle client 12.1.0.1.0 for Linux.

OS is RHEL 6.2 64 bit.
Oracle client is Linux 64 bit 12.1.0.1.0.

I just removed it from binding.gyp, and everything builds and works fine.

Thanks

Problems to install node-oracle on windows8 64bits

[email protected] install C:\Igor\Node.JS\teste\node_modules\oracle
node-gyp rebuild

I have many issues to install windows 8 64bits node v0.10.12. Can you help me please?

C:\Igor\Node.JS\teste\node_modules\oracle>node "C:\Program Files (x86)\nodejs\node_modules\npm\bin\node-gyp-bin....\node_modules\node-gyp\bin\node-gyp.js" rebuild
Compilando os projetos desta solu‡Æo um de cada vez. Para habilitar a compila‡Æo paralela, adicione a op‡Æo "/m".
executeBaton.cpp
outParam.cpp
connection.cpp
oracle_bindings.cpp
C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\include\xlocale(336): warning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc (..\src\outParam.cpp) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\include\xlocale(336): warning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc (..\src\oracle_bindings.cpp) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\include\xlocale(336): warning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc (..\src\executeBaton.cpp) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\include\xlocale(336): warning C4530: C++ exception handler used, but unwind semantics are not enabled. Specify /EHsc (..\src\connection.cpp) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
..\src\outParam.cpp(23): warning C4244: '=' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
..\src\outParam.cpp(27): warning C4244: '=' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
..\src\outParam.cpp(34): warning C4244: '=' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
..\src\outParam.cpp(42): warning C4244: '=' : conversion from 'double' to 'float', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
..\src\outParam.cpp(42): warning C4244: '=' : conversion from 'int' to 'float', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
..\src\oracle_bindings.cpp(67): warning C4244: '=' : conversion from 'double' to 'uint32_t', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
..\src\executeBaton.cpp(61): warning C4244: 'initializing' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
..\src\executeBaton.cpp(62): warning C4244: 'initializing' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
..\src\executeBaton.cpp(63): warning C4244: 'initializing' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
..\src\executeBaton.cpp(64): warning C4244: 'initializing' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
..\src\executeBaton.cpp(65): warning C4244: 'initializing' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
..\src\executeBaton.cpp(66): warning C4244: 'initializing' : conversion from 'double' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
..\src\connection.cpp(596): warning C4267: 'argument' : conversion from 'size_t' to 'int', possible loss of data [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\include\xlocnum(155): warning C4506: no definition for inline function 'v8::Persistent v8::Persistent::New(v8::Handle)' [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
with

T=v8::Object

C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\include\xlocnum(155): warning C4506: no definition for inline function 'v8::Persistent v8::Persistent::New(v8::Handle)' [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
with

T=v8::FunctionTemplate

C:\Users\IMaia.node-gyp\0.10.12\deps\v8\include\v8.h(218): warning C4506: no definition for inline function 'v8::Persistent v8::Persistent::New(v8::Handle)' [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
with

T=v8::Object

C:\Users\IMaia.node-gyp\0.10.12\deps\v8\include\v8.h(218): warning C4506: no definition for inline function 'v8::Persistent v8::Persistent::New(v8::Handle)' [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
with

T=v8::FunctionTemplate

C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\include\xmemory0(605): warning C4506: no definition for inline function 'v8::Persistent v8::Persistent::New(v8::Handle)' [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
with

T=v8::Object

C:\Users\IMaia.node-gyp\0.10.12\deps\v8\include\v8.h(218): warning C4506: no definition for inline function 'v8::Persistent v8::Persistent::New(v8::Handle)' [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
with

T=v8::Object

C:\Users\IMaia.node-gyp\0.10.12\deps\v8\include\v8.h(218): warning C4506: no definition for inline function 'v8::Persistent v8::Persistent::New(v8::Handle)' [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
with

T=v8::FunctionTemplate

Creating library C:\Igor\Node.JS\teste\node_modules\oracle\build\Release\oracle_bindings.lib and object C:\Igor\Node.JS\teste\node_modules\oracle\build\Release\oracle_bindings.exp
executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Clob::~Clob(void)" (??1Clob@occi@oracle@@qeaa@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Clob::Clob(void)" (??0Clob@occi@oracle@@qeaa@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Blob::~Blob(void)" (??1Blob@occi@oracle@@qeaa@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Blob::Blob(void)" (??0Blob@occi@oracle@@qeaa@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Date::~Date(void)" (??1Date@occi@oracle@@qeaa@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Date::Date(void)" (??0Date@occi@oracle@@qeaa@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Date::Date(class oracle::occi::Environment const _,int,unsigned int,unsigned int,unsigned int,unsigned int,unsigned int)" (??0Date@occi@oracle@@qeaa@PEBVEnvironment@12@HIIIII@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Timestamp::~Timestamp(void)" (??1Timestamp@occi@oracle@@qeaa@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Timestamp::Timestamp(void)" (??0Timestamp@occi@oracle@@qeaa@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Number::~Number(void)" (??1Number@occi@oracle@@qeaa@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Number::Number(void)" (??0Number@occi@oracle@@qeaa@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
executeBaton.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Number::Number(double)" (??0Number@occi@oracle@@qeaa@N@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
outParam.obj : error LNK2001: unresolved external symbol "public: class oracle::occi::Number & __cdecl oracle::occi::Number::operator=(class oracle::occi::Number const &)" (??4Number@occi@oracle@@QEAAAEAV012@AEBV012@@z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
outParam.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Number::Number(int)" (??0Number@occi@oracle@@qeaa@H@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Clob::closeStream(class oracle::occi::Stream *)" (?closeStream@Clob@occi@oracle@@QEAAXPEAVStream@23@@z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: class oracle::occi::Stream * __cdecl oracle::occi::Clob::getStream(unsigned int,unsigned int)" (?getStream@Clob@occi@oracle@@QEAAPEAVStream@23@II@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Clob::close(void)" (?close@Clob@occi@oracle@@QEAAXXZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Clob::open(enum oracle::occi::LobOpenMode)" (?open@Clob@occi@oracle@@QEAAXW4LobOpenMode@23@@z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: class oracle::occi::Clob & __cdecl oracle::occi::Clob::operator=(class oracle::occi::Clob const &)" (??4Clob@occi@oracle@@QEAAAEAV012@AEBV012@@z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Clob::setCharSetForm(enum oracle::occi::CharSetForm)" (?setCharSetForm@Clob@occi@oracle@@QEAAXW4CharSetForm@23@@z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: unsigned int __cdecl oracle::occi::Clob::length(void)const " (?length@Clob@occi@oracle@@QEBAIXZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Blob::closeStream(class oracle::occi::Stream *)" (?closeStream@Blob@occi@oracle@@QEAAXPEAVStream@23@@z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: class oracle::occi::Stream * __cdecl oracle::occi::Blob::getStream(unsigned int,unsigned int)" (?getStream@Blob@occi@oracle@@QEAAPEAVStream@23@II@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Blob::close(void)" (?close@Blob@occi@oracle@@QEAAXXZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Blob::open(enum oracle::occi::LobOpenMode)" (?open@Blob@occi@oracle@@QEAAXW4LobOpenMode@23@@z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: class oracle::occi::Blob & __cdecl oracle::occi::Blob::operator=(class oracle::occi::Blob const &)" (??4Blob@occi@oracle@@QEAAAEAV012@AEBV012@@z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: unsigned int __cdecl oracle::occi::Blob::length(void)const " (?length@Blob@occi@oracle@@QEBAIXZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: class oracle::occi::Date & __cdecl oracle::occi::Date::operator=(class oracle::occi::Date const &)" (??4Date@occi@oracle@@QEAAAEAV012@AEBV012@@z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Date::getDate(int &,unsigned int &,unsigned int &,unsigned int &,unsigned int &,unsigned int &)const " (?getDate@Date@occi@oracle@@QEBAXAEAHAEAI1111@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: class oracle::occi::Timestamp & __cdecl oracle::occi::Timestamp::operator=(class oracle::occi::Timestamp const &)" (??4Timestamp@occi@oracle@@QEAAAEAV012@AEBV012@@z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Timestamp::getDate(int &,unsigned int &,unsigned int &)const " (?getDate@Timestamp@occi@oracle@@QEBAXAEAHAEAI1@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: void __cdecl oracle::occi::Timestamp::getTime(unsigned int &,unsigned int &,unsigned int &,unsigned int &)const " (?getTime@Timestamp@occi@oracle@@QEBAXAEAI000@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::Number::operator double(void)const " (??BNumber@occi@oracle@@QEBANXZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::MetaData::~MetaData(void)" (??1MetaData@occi@oracle@@qeaa@XZ) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: class std::basic_string<char,struct std::char_traits,class std::allocator > __cdecl oracle::occi::MetaData::getString(enum oracle::occi::MetaData::AttrId)const " (?getString@MetaData@occi@oracle@@qeba?AV?$basic_string@DU?$char_traits@D@std@@v?$allocator@D@2@@std@@W4AttrId@123@@z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: int __cdecl oracle::occi::MetaData::getInt(enum oracle::occi::MetaData::AttrId)const " (?getInt@MetaData@occi@oracle@@QEBAHW4AttrId@123@@z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
connection.obj : error LNK2001: unresolved external symbol "public: __cdecl oracle::occi::MetaData::MetaData(class oracle::occi::MetaData const &)" (??0MetaData@occi@oracle@@qeaa@AEBV012@@z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
oracle_bindings.obj : error LNK2001: unresolved external symbol "public: static void __cdecl oracle::occi::Environment::terminateEnvironment(class oracle::occi::Environment *)" (?terminateEnvironment@Environment@occi@oracle@@SAXPEAV123@@z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
oracle_bindings.obj : error LNK2001: unresolved external symbol "public: static class oracle::occi::Environment * __cdecl oracle::occi::Environment::createEnvironment(enum oracle::occi::Environment::Mode,void *,void * (_cdecl)(void _,unsigned __int64),void * (_cdecl)(void _,void *,unsigned __int64),void (_cdecl)(void *,void *))" (?createEnvironment@Environment@occi@oracle@@SAPEAV123@W4Mode@123@PEAXP6APEAX1_K@ZP6APEAX112@ZP6AX11@Z@Z) [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]
C:\Igor\Node.JS\teste\node_modules\oracle\build\Release\oracle_bindings.node : fatal error LNK1120: 39 unresolved externals [C:\Igor\Node.JS\teste\node_modules\oracle\build\oracle_bindings.vcxproj]

gyp ERR! build error
gyp ERR! stack Error: msbuild failed with exit code: 1
gyp ERR! stack at ChildProcess.onExit (C:\Program Files (x86)\nodejs\node_mo
dules\npm\node_modules\node-gyp\lib\build.js:267:23)
gyp ERR! stack at ChildProcess.EventEmitter.emit (events.js:98:17)
gyp ERR! stack at Process.ChildProcess._handle.onexit (child_process.js:789:
12)
gyp ERR! System Windows_NT 6.2.9200
gyp ERR! command "node" "C:\Program Files (x86)\nodejs\node_modules\npm\nod
e_modules\node-gyp\bin\node-gyp.js" "rebuild"
gyp ERR! cwd C:\Igor\Node.JS\teste\node_modules\oracle
gyp ERR! node -v v0.10.12
gyp ERR! node-gyp -v v0.10.0
gyp ERR! not ok
npm ERR! weird error 1
npm ERR! not ok code 0

C:\Igor\Node.JS\teste>npm install oracle >>erro.txt
npm http GET https://registry.npmjs.org/oracle
npm http 304 https://registry.npmjs.org/oracle
gyp ERR! build error
gyp ERR! stack Error: msbuild failed with exit code: 1
gyp ERR! stack at ChildProcess.onExit (C:\Program Files (x86)\nodejs\node_mo
dules\npm\node_modules\node-gyp\lib\build.js:267:23)
gyp ERR! stack at ChildProcess.EventEmitter.emit (events.js:98:17)
gyp ERR! stack at Process.ChildProcess._handle.onexit (child_process.js:789:
12)
gyp ERR! System Windows_NT 6.2.9200
gyp ERR! command "node" "C:\Program Files (x86)\nodejs\node_modules\npm\nod
e_modules\node-gyp\bin\node-gyp.js" "rebuild"
gyp ERR! cwd C:\Igor\Node.JS\teste\node_modules\oracle
gyp ERR! node -v v0.10.12
gyp ERR! node-gyp -v v0.10.0
gyp ERR! not ok
npm ERR! weird error 1
npm ERR! not ok code 0

Handling Oracle types that JavaScript/Node can't handle

Now that we can connect to Oracle we are experiencing a new suite of problems. The stored procs we must call have data types that JS/Node.js can't handle directly. We can't ask the DB team to change the procs because this would require a cascading set of changes to C++ and Java code that is not currently under development and expects the values from these stored procs to remain constant. So far we have encountered two specific problems:

Error: CreateColumnsFromResultSet: Unhandled oracle data type: 101

We believe this is being caused by a column in the results cursor that is of type binary_double. The second problem we are having is with some Number fields that are relying on 20 digits of precision. Because JavaScript supports only double precision floating point, the data is getting lost after the 16th digit. Unfortunately we need every digit since these numbers represent an account number. We did an experiment where we cast the binary_double to a float and cast the 20 digit Number to a string. This worked. But as I said we can't really change the stored procs.

It would seem this must be a problem other's have encountered. I see that you can specify the type of an OUTPARAM as in code like this:

connection.execute("call myProc(:1,:2)", ["nodejs", new oracle.OutParam(oracle.OCCISTRING)], function(err, results)

The challenge I have is that the result of the stored proc in my case is a results cursor with 58 columns of data for each result set. Of that data, most is of Oracle type "Number" with one field of type binary_double. I see in the source code where the CreateColumnsFromResultSet function is implemented and we could muck around with a copy of that function that takes an additional array of types to cast the columns too, but that seems ugly and we'd rather not modify your module if we can help it.

Is there a solution to this already in place that I am missing? Basically we want to cast data in the results from types unsupported in JavaScript/Node.js to types that are. Thanks in advance for any help. I am a bit of an Oracle Noob but have been programming professionally for more decades than I care to say! Oh how I wish this code were MySQL!!!

Hard time building, not running on OS X

Great work! Unfortunately, it doesn't work on OS X (Lion)

After getting npm/mnm to use the correct library/include paths, it complains about being unable to find lib nnz11. nnz11 is NOT part of the Oracle InstantClient for OS X.

nnz10 is part of the Oracle InstantClient for OS X, however. After linking against that I get the following:

[Steven ~]$ node

require('oracle')
Segmentation fault: 11

Libraries oracle_bindings.node is linked against:

[Steven ~/node_modules/oracle/build/Release]$ otool -L oracle_bindings.node
oracle_bindings.node:
/opt/local/lib/oracle/libocci.dylib.10.1 (compatibility version 0.0.0, current version 0.0.0)
/opt/local/lib/oracle/libclntsh.dylib.10.1 (compatibility version 0.0.0, current version 0.0.0)
/opt/local/lib/oracle/libnnz10.dylib (compatibility version 0.0.0, current version 0.0.0)
/usr/lib/libstdc++.6.dylib (compatibility version 7.0.0, current version 52.0.0)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 159.1.0)

Failing to build on Windows

Hi guys,

I'm runnin Node 0.8.8, getting this issue buildilng on windows, any ideas?

[1/5] cxx: src\connection.cpp -> build\Release\src\connection.obj
CreateProcessW: The system cannot find the file specified.
[2/5] cxx: src\executeBaton.cpp -> build\Release\src\executeBaton.obj
CreateProcessW: The system cannot find the file specified.
[3/5] cxx: src\oracle_bindings.cpp -> build\Release\src\oracle_bindings.obj
CreateProcessW: The system cannot find the file specified.
[4/5] cxx: src\outParam.cpp -> build\Release\src\outParam.obj
CreateProcessW: The system cannot find the file specified.

error installing node-oracle

Hi, i was trying to install the node-oracle i got the below error

i have copied the instance client package in the nodejs folder is this correct, please tell me if i need to copy it to specific path.

ERROR: You must specify NODE_HOME.
npm ERR! [email protected] install: node mnm.js build
npm ERR! cmd "/c" "node mnm.js build" failed with 1
npm ERR!
npm ERR! Failed at the [email protected] install script.
npm ERR! This is most likely a problem with the oracle package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR! node mnm.js build
npm ERR! You can get their info via:
npm ERR! npm owner ls oracle
npm ERR! There is likely additional logging output above.

npm ERR! System Windows_NT 6.1.7601
npm ERR! command "C:\nodejs\node.exe" "C:\nodejs\node_modules\npm\bin\npm-cli.js" "install" "oracle"
npm ERR! cwd C:\nodejs
npm ERR! node -v v0.8.19
npm ERR! npm -v 1.2.10
npm ERR! code ELIFECYCLE
npm ERR!
npm ERR! Additional logging details can be found in:
npm ERR! C:\nodejs\npm-debug.log
npm ERR! not ok code 0

Does the node-oracle module do any type of connection pooling under-the-hood?

Hi. I realize this probably isn't the right place to ask this, but I couldn't find a general discussion. I've looked in the C++ code and I don't see anything that looks like the module is managing it's own connection pool. Am I correct that the module does not manage a pool of connections?

A related questions: in the OCI drivers for other languages, such as PHP, there's a difference between a connection and a persistent connection (in PHP oci_connect vs oci_pconnect). Again looking through the C++ source I don't see an equivalent of oci_pconnect for persistent connections.

Feel free to suggest where I should post messages like this. It is likely I will have additional comments and questions as I complete my project for a major entertainment company that is using this module.

error installing oracle

Hi guys,

I have problems installing oracle into my nodejs. below is the error. Please help. thanks

risto@risto-Lenovo-G460:~/NetBeansProjects/AdNode$ npm install oracle
npm http GET https://registry.npmjs.org/oracle
npm http 304 https://registry.npmjs.org/oracle

[email protected] install /home/risto/NetBeansProjects/AdNode/node_modules/oracle
node-gyp rebuild

make: Entering directory /home/risto/NetBeansProjects/AdNode/node_modules/oracle/build' CXX(target) Release/obj.target/oracle_bindings/src/connection.o CXX(target) Release/obj.target/oracle_bindings/src/oracle_bindings.o CXX(target) Release/obj.target/oracle_bindings/src/executeBaton.o CXX(target) Release/obj.target/oracle_bindings/src/outParam.o SOLINK_MODULE(target) Release/obj.target/oracle_bindings.node /usr/bin/ld: cannot find -locci /usr/bin/ld: cannot find -lclntsh /usr/bin/ld: cannot find -lnnz11 collect2: error: ld returned 1 exit status make: *** [Release/obj.target/oracle_bindings.node] Error 1 make: Leaving directory/home/risto/NetBeansProjects/AdNode/node_modules/oracle/build'
gyp ERR! build error
gyp ERR! stack Error: make failed with exit code: 2
gyp ERR! stack at ChildProcess.onExit (/usr/lib/node_modules/npm/node_modules/node-gyp/lib/build.js:267:23)
gyp ERR! stack at ChildProcess.EventEmitter.emit (events.js:98:17)
gyp ERR! stack at Process.ChildProcess._handle.onexit (child_process.js:789:12)
gyp ERR! System Linux 3.8.0-22-generic
gyp ERR! command "node" "/usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "rebuild"
gyp ERR! cwd /home/risto/NetBeansProjects/AdNode/node_modules/oracle
gyp ERR! node -v v0.10.8
gyp ERR! node-gyp -v v0.9.5
gyp ERR! not ok
npm ERR! weird error 1
npm ERR! not ok code 0

Update Docs to include Database in oracle.connect

I spent quite some time trying to figure out why I was getting ORA-12514 and after reviewing the source code for oracle_bindings.cpp I noticed there is a database argument and this is not actually read from the ORACLE_SID environment variable per the instructions or samples provided in the readme.

oracle.connect({ "hostname": "localhost", "user": "abc", "password": "def", "database": "SERVICE_NAME" }, function(err, connection) {
  if(err) { throw new Error(err); }
  if(connection) { 
     // do your thing here
     connection.close(); // close your connection when you are done
   }
});

select * from x where y in(a,b) doesn't work

hi,

i tried this query :

connection.execute("select OBJECTID from IMMEUBLES where VOIE in (:1)",
[" '1 RUE ARNOLD SCHOENBERG', '3 ROND-POINT DES SAULES' "],
function(err, results) {
  console.log(results);
});

but it returns no results when it should have returned 2 values.

i also tried to put those value in an array :

var adresses = new Array('1 RUE ARNOLD SCHOENBERG', '3 ROND-POINT DES SAULES');
connection.execute("select OBJECTID from IMMEUBLES where VOIE in (:1)",
adresses,
function(err, results) {
  console.log(results);
});

then i get this error :

Error: ORA-32109: invalid column or parameter position

how can i solve this ? what am i doing wrong ?
thank you for your time and for this driver

Checking for header occi.h : Missing include files for OCI

Hello, I'm trying to compile node-oracle but I get an error:

$ node-waf configureChecking for program g++ or c++          : /usr/bin/g++ 
Checking for program cpp                 : /usr/bin/cpp 
Checking for program ar                  : /usr/bin/ar 
Checking for program ranlib              : /usr/bin/ranlib 
Checking for g++                         : ok  
Checking for node path                   : not found 
Checking for node prefix                 : ok /usr/local 
Checking for header occi.h               : Missing include files for OCI 
/tmp/oracle/node-oracle/wscript:35: error: the configuration failed (see '/tmp/oracle/node-oracle/build/config.log')

Looking config.log:

Checking for header occi.h
==>
#include <occi.h>

int main() {
        return 0;
}

<==
[1/2] ESC[32mcxx: build/.conf_check_0/test.cpp -> build/.conf_check_0/testbuild/Release/test_1.o
ESC[0m['/usr/bin/g++', '-g', '-Wall', '-I/var/lib/oracle/app/oracle/product/11.2.0/client_1/rdbms/public', '../test.cpp', '-c', '-o', 'Release/test_1.o']
[2/2] ESC[33mcxx_link: build/.conf_check_0/testbuild/Release/test_1.o -> build/.conf_check_0/testbuild/Release/testprog
ESC[0m/usr/bin/ld: cannot find -lnnz10
collect2: ld devolvió el estado de salida 1
['/usr/bin/g++', 'Release/test_1.o', '-o', '/home/aoramire/Desarrollo/tmp/oracle/node-oracle/build/.conf_check_0/testbuild/Release/testprog', '-L/var/lib/oracle/app/oracle/product/11.2.0/client_1/lib', '-locci', '-lclntsh', '-lnnz10']
command returned 'Build failed:  -> task failed (err #1): \n\t{task: cxx_link test_1.o -> testprog}'Missing include files for OCI

And env vars:

$ set | grep -E "ORA|OCI|TNS|LD_LIB"
LD_LIBRARY_PATH=:/var/lib/oracle/app/oracle/product/11.2.0/client_1/lib
OCI_INCLUDE_DIR=/var/lib/oracle/app/oracle/product/11.2.0/client_1/rdbms/public
OCI_LIB_DIR=/var/lib/oracle/app/oracle/product/11.2.0/client_1/lib
ORACLE_BASE=/var/lib/oracle
ORACLE_HOME=/var/lib/oracle/app/oracle/product/11.2.0/client_1
TNS_ADMIN=/var/lib/oracle/app/oracle/product/11.2.0/client_1/network/admin

What occurs?

Oracle stored procedure with OUT parameters

I have an Oracle stored procedure like this:

CREATE OR REPLACE PROCEDURE Sp_CheckName(in_Name IN VARCHAR2, out_Ret OUT VARCHAR2) IS
cnt NUMBER;
BEGIN
SELECT COUNT(1) INTO cnt FROM Person WHERE NAME = in_Name;
out_Ret := cnt;
END Sp_CheckName;

Is any idea for me to get out_Ret value in javascript by node-oracle?
Thanks.

Timestamp timezones are ignored

Commit a19b9e0 added basic support for Timestamp with timezone and Timestamp with local timezone, but still does not properly calculate the UTC time based on the timezone information.

I've made a quick attempt at handling the timezone, but I would like some feedback about this approach. It's necessary to know whether the Timestamp coming into OracleTimestampToV8Date(...) has timezone information because the call to d->getTimeZoneOffset(...) will always return something, even if the type was a Timestamp without timezone.

What do you think about the approach of handling all Timestamp types in a single function? johannish/node-oracle@95875370

npm install oracle errors

Hi there,
Getting these when running npm install oracle

$ npm install oracle
npm http GET https://registry.npmjs.org/oracle
npm http 304 https://registry.npmjs.org/oracle

> [email protected] install /Users/seb/node_modules/oracle
> node mnm.js build

[1/5] cxx: src/connection.cpp -> build/Release/src/connection.o
In file included from /Users/seb/node_modules/oracle/src/connection.cpp:2:
...

using node 10.4 and npm 1.2.18

I cloned locally the repo and ran node-gyp configure & build, and although build succeeds, I am getting uncaught exceptions when connecting:

> var config = { ... }
> var oracle = require('./build/Release/oracle_bindings.node')
undefined
> oracle
{ OracleClient: [Function: OracleClient],
  Connection: [Function: Connection],
  OutParam: [Function: OutParam] }
> var client = new OracleClient
> client.connect(config, function(e,r) { console.log('connected') });
undefined
> terminate called throwing an exceptionAbort trap: 6

This is all done MacOsx. The strange thing is that I had the driver working corectly on node 0.8.6 (?) and was able to use it successfully.

error while installing oracle pckg

i got the below error message while installing oracle

C:\nodejs>npm install oracle
npm http GET https://registry.npmjs.org/oracle
npm http 304 https://registry.npmjs.org/oracle

[email protected] install C:\nodejs\node_modules\oracle
node-gyp rebuild

C:\nodejs\node_modules\oracle>node "C:\nodejs\node_modules\npm\bin\node-gyp-bin....\node_modules\node-gyp\bin\node-gyp.js" rebuild
-z was unexpected at this time.
gyp: Call to 'if [ -z $OCI_LIB_DIR ]; then echo "/opt/instantclient/"; else echo $OCI_LIB_DIR; fi' returned exit status 1. while trying to load bindin
g.gyp
gyp ERR! configure error
gyp ERR! stack Error: gyp failed with exit code: 1
gyp ERR! stack at ChildProcess.onCpExit (C:\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:416:16)
gyp ERR! stack at ChildProcess.EventEmitter.emit (events.js:99:17)
gyp ERR! stack at Process._handle.onexit (child_process.js:678:10)
gyp ERR! System Windows_NT 6.1.7601
gyp ERR! command "node" "C:\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "rebuild"
gyp ERR! cwd C:\nodejs\node_modules\oracle
gyp ERR! node -v v0.8.19
gyp ERR! node-gyp -v v0.8.4
gyp ERR! not ok
npm ERR! [email protected] install: node-gyp rebuild
npm ERR! cmd "/c" "node-gyp rebuild" failed with 1
npm ERR!
npm ERR! Failed at the [email protected] install script.
npm ERR! This is most likely a problem with the oracle package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR! node-gyp rebuild
npm ERR! You can get their info via:
npm ERR! npm owner ls oracle
npm ERR! There is likely additional logging output above.

npm ERR! System Windows_NT 6.1.7601
npm ERR! command "C:\nodejs\node.exe" "C:\nodejs\node_modules\npm\bin\npm-cli.js" "install" "oracle"
npm ERR! cwd C:\nodejs
npm ERR! node -v v0.8.19
npm ERR! npm -v 1.2.10
npm ERR! code ELIFECYCLE
npm ERR!
npm ERR! Additional logging details can be found in:
npm ERR! C:\nodejs\npm-debug.log
npm ERR! not ok code 0

Oracle Rac

Hi,

I want to connect to oracle rac. Rac have two or more addresses. JDBC have connection string to connect. How node-oracle to connect rac?

terminate called throwing an exception

I got this quite often:

terminate called throwing an exception[1]    11168 abort      node xxx.js

reasons:

1. the Connection has just been closed, when a callback is invoked that tries to do something with that connection

2. The connection parameters only contain user, password and "tnx" (instead of "tns")

3. Invoking:

   connection.execute(
     "INSERT INTO benutzer (name) VALUES (:1) RETURNING id INTO :2",
     ['joe ferner', new oracle.OutParam()],
     function(err, results) {
       if ( err ) { 
         console.log(err) 
       } else {
         console.log(results);
       } 
     }
   );
   

   when the id is not automatically created and returned.

Or is this just something new in Node 0.10.x (have just migrated from 0.8.x)

Failed build in Mac ML

Please someone help me.
I'm use Mac OS ML.
I unzipped the oracle basic and sdk in /opt/instantclient and /opt/instantclient/sdk
and export:
export OCI_INCLUDE_DIR=/opt/instantclient/sdk/include/
export OCI_LIB_DIR=/opt/instantclient/

both in /etc/profile and ~/.bash_profile
and use "source" command to take it's effect.
I test the export to use:
echo $OCI_INCLUDE_DIR
then command line return /opt/instantclient/sdk/include/

all above it's ok.

when I npm install oracle, it says:
ERROR: Could not find "/usr/include/oracle/11.2/client" check OCI_INCLUDE_DIR environment variable.

my exports is not take effect?
and then i copied the /opt/instantclient/sdk/include/ to /usr/include/oracle/11.2/client

and copied the /opt/instantclient/ to /usr/include/oracle/11.2/client/lib

it works!

but in building it report the error：
npm WARN package.json [email protected] No README.md file found!
npm http GET https://registry.npmjs.org/oracle
npm http 304 https://registry.npmjs.org/oracle
npm http GET https://registry.npmjs.org/mnm
npm http 304 https://registry.npmjs.org/mnm

[email protected] install /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle
node mnm.js build

[1/5] cxx: src/connection.cpp -> build/Release/src/connection.o
In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.cpp:2:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:5:16: error: v8.h: No such file or directory
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:6:18: error: node.h: No such file or directory
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.cpp:8:26: error: node_version.h: No such file or directory
In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:14,
from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.cpp:2:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:45: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:45: error: expected ‘,’ or ‘...’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:49: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:49: error: ISO C++ forbids declaration of ‘Persistent’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:49: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:59: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:59: error: expected ‘,’ or ‘...’ before ‘<’ token
In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.cpp:2:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:16: error: ‘node’ is not a namespace-name
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:16: error: expected namespace-name before ‘;’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:17: error: ‘v8’ is not a namespace-name
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:17: error: expected namespace-name before ‘;’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:19: error: expected class-name before ‘{’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:21: error: ‘Handle’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:21: error: expected ‘,’ or ‘...’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:22: error: ISO C++ forbids declaration of ‘Handle’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:22: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:23: error: ISO C++ forbids declaration of ‘Handle’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:23: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:24: error: ISO C++ forbids declaration of ‘Handle’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:24: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:25: error: ISO C++ forbids declaration of ‘Handle’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:25: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:26: error: ISO C++ forbids declaration of ‘Handle’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:26: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:27: error: ISO C++ forbids declaration of ‘Handle’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:27: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:28: error: ISO C++ forbids declaration of ‘Persistent’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:28: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:29: error: ‘uv_work_t’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:30: error: ‘uv_work_t’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:31: error: ‘uv_work_t’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:32: error: ‘uv_work_t’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:33: error: ‘uv_work_t’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:34: error: ‘uv_work_t’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:47: error: ISO C++ forbids declaration of ‘Local’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:47: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:48: error: ISO C++ forbids declaration of ‘Local’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:48: error: expected ‘;’ before ‘<’ token
In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.cpp:4:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/commitBaton.h:9: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/commitBaton.h:9: error: expected ‘,’ or ‘...’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/commitBaton.h:18: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/commitBaton.h:18: error: ISO C++ forbids declaration of ‘Persistent’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/commitBaton.h:18: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/commitBaton.h: In constructor ‘CommitBaton::CommitBaton(Connection_, int)’:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/commitBaton.h:11: error: ‘class CommitBaton’ has no member named ‘callback’
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/commitBaton.h:11: error: ‘Persistent’ was not declared in this scope
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/commitBaton.h:11: error: ‘Function’ was not declared in this scope
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/commitBaton.h:11: error: ‘::New’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/commitBaton.h:11: error: ‘callback’ was not declared in this scope
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/commitBaton.h: In destructor ‘CommitBaton::~CommitBaton()’:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/commitBaton.h:14: error: ‘callback’ was not declared in this scope
In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.cpp:5:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/rollbackBaton.h: At global scope:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/rollbackBaton.h:9: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/rollbackBaton.h:9: error: expected ‘,’ or ‘...’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/rollbackBaton.h:18: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/rollbackBaton.h:18: error: ISO C++ forbids declaration of ‘Persistent’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/rollbackBaton.h:18: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/rollbackBaton.h: In constructor ‘RollbackBaton::RollbackBaton(Connection_, int)’:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/rollbackBaton.h:11: error: ‘class RollbackBaton’ has no member named ‘callback’
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/rollbackBaton.h:11: error: ‘Persistent’ was not declared in this scope
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/rollbackBaton.h:11: error: ‘Function’ was not declared in this scope
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/rollbackBaton.h:11: error: ‘::New’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/rollbackBaton.h:11: error: ‘callback’ was not declared in this scope
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/rollbackBaton.h: In destructor ‘RollbackBaton::~RollbackBaton()’:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/rollbackBaton.h:14: error: ‘callback’ was not declared in this scope
In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.cpp:6:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h: At global scope:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:12: error: ‘node’ is not a namespace-name
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:12: error: expected namespace-name before ‘;’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:13: error: ‘v8’ is not a namespace-name
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:13: error: expected namespace-name before ‘;’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:15: error: expected class-name before ‘{’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:17: error: ‘Handle’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:17: error: expected ‘,’ or ‘...’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:18: error: ISO C++ forbids declaration of ‘Handle’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:18: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:19: error: ISO C++ forbids declaration of ‘Persistent’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:19: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.cpp:10: error: expected constructor, destructor, or type conversion before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.cpp:12: error: variable or field ‘Init’ declared void
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.cpp:12: error: ‘Handle’ was not declared in this scope
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.cpp:12: error: ‘Object’ was not declared in this scope
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.cpp:12: error: ‘target’ was not declared in this scope
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.cpp:29: error: expected constructor, destructor, or type conversion before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.cpp:44: error: expected constructor, destructor, or type conversion before ‘<’ token
[2/5] cxx: src/executeBaton.cpp -> build/Release/src/executeBaton.o
In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:2:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:7:16: error: v8.h: No such file or directory
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:8:18: error: node.h: No such file or directory
In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:2:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:45: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:45: error: expected ‘,’ or ‘...’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:49: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:49: error: ISO C++ forbids declaration of ‘Persistent’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:49: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:59: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:59: error: expected ‘,’ or ‘...’ before ‘<’ token
In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:3:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:12: error: ‘node’ is not a namespace-name
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:12: error: expected namespace-name before ‘;’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:13: error: ‘v8’ is not a namespace-name
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:13: error: expected namespace-name before ‘;’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:15: error: expected class-name before ‘{’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:17: error: ‘Handle’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:17: error: expected ‘,’ or ‘...’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:18: error: ISO C++ forbids declaration of ‘Handle’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:18: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:19: error: ISO C++ forbids declaration of ‘Persistent’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:19: error: expected ‘;’ before ‘<’ token
In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:5:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:16: error: ‘node’ is not a namespace-name
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:16: error: expected namespace-name before ‘;’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:17: error: ‘v8’ is not a namespace-name
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:17: error: expected namespace-name before ‘;’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:19: error: expected class-name before ‘{’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:21: error: ‘Handle’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:21: error: expected ‘,’ or ‘...’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:22: error: ISO C++ forbids declaration of ‘Handle’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:22: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:23: error: ISO C++ forbids declaration of ‘Handle’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:23: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:24: error: ISO C++ forbids declaration of ‘Handle’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:24: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:25: error: ISO C++ forbids declaration of ‘Handle’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:25: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:26: error: ISO C++ forbids declaration of ‘Handle’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:26: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:27: error: ISO C++ forbids declaration of ‘Handle’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:27: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:28: error: ISO C++ forbids declaration of ‘Persistent’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:28: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:29: error: ‘uv_work_t’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:30: error: ‘uv_work_t’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:31: error: ‘uv_work_t’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:32: error: ‘uv_work_t’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:33: error: ‘uv_work_t’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:34: error: ‘uv_work_t’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:47: error: ISO C++ forbids declaration of ‘Local’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:47: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:48: error: ISO C++ forbids declaration of ‘Local’ with no type
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:48: error: expected ‘;’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:7: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:7: error: expected ‘,’ or ‘...’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp: In constructor ‘ExecuteBaton::ExecuteBaton(Connection_, const char_, int)’:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:10: error: ‘class ExecuteBaton’ has no member named ‘callback’
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:10: error: ‘Persistent’ was not declared in this scope
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:10: error: ‘Function’ was not declared in this scope
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:10: error: ‘::New’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:10: error: ‘callback’ was not declared in this scope
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:12: error: no matching function for call to ‘ExecuteBaton::CopyValuesToBaton(ExecuteBaton* const, std::vector<value_t*, std::allocator<value_t*> >&)’
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:59: note: candidates are: static void ExecuteBaton::CopyValuesToBaton(ExecuteBaton_, int)
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp: In destructor ‘ExecuteBaton::~ExecuteBaton()’:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:16: error: ‘callback’ was not declared in this scope
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp: At global scope:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:42: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:42: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:42: error: ‘date’ was not declared in this scope
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:42: error: expected primary-expression before ‘const’
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:42: error: initializer expression list treated as compound expression
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:42: error: expected ‘,’ or ‘;’ before ‘{’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:48: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:48: error: expected ‘,’ or ‘...’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp: In function ‘oracle::occi::Date_ V8DateToOcciDate(oracle::occi::Environment_, int)’:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:49: error: ‘val’ was not declared in this scope
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:49: error: ‘CallDateMethod’ cannot be used as a function
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:50: error: ‘CallDateMethod’ cannot be used as a function
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:51: error: ‘CallDateMethod’ cannot be used as a function
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:52: error: ‘CallDateMethod’ cannot be used as a function
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:53: error: ‘CallDateMethod’ cannot be used as a function
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:54: error: ‘CallDateMethod’ cannot be used as a function
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp: At global scope:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:59: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:59: error: expected ‘,’ or ‘...’ before ‘<’ token
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h: In static member function ‘static void ExecuteBaton::CopyValuesToBaton(ExecuteBaton_, int)’:
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:50: error: invalid use of member ‘ExecuteBaton::values’ in static member function
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:60: error: from this location
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:61: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:61: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:61: error: ‘val’ was not declared in this scope
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:50: error: invalid use of member ‘ExecuteBaton::values’ in static member function
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:61: error: from this location
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:74: error: ‘v8’ has not been declared
/Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:74: error: expected ;' before ‘asciiVal’ /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:76: error: ‘asciiVal’ was not declared in this scope /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:83: error: ‘v8’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:90: error: ‘v8’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:96: error: ‘constructorTemplate’ is not a member of ‘OutParam’ /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.cpp:96: error: ‘v8’ has not been declared [3/5] cxx: src/oracle_bindings.cpp -> build/Release/src/oracle_bindings.o In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.cpp:2: /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:5:16: error: v8.h: No such file or directory /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:6:18: error: node.h: No such file or directory In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.cpp:2: /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:13: error: ‘node’ is not a namespace-name /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:13: error: expected namespace-name before ‘;’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:14: error: ‘v8’ is not a namespace-name /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:14: error: expected namespace-name before ‘;’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:16: error: expected class-name before ‘{’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:18: error: ‘Handle’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:18: error: expected ‘,’ or ‘...’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:19: error: ISO C++ forbids declaration of ‘Handle’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:19: error: expected ‘;’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:20: error: ISO C++ forbids declaration of ‘Handle’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:20: error: expected ‘;’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:21: error: ‘uv_work_t’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:22: error: ‘uv_work_t’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:28: error: ISO C++ forbids declaration of ‘Persistent’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.h:28: error: expected ‘;’ before ‘<’ token In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:14, from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.cpp:3: /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:45: error: ‘v8’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:45: error: expected ‘,’ or ‘...’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:49: error: ‘v8’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:49: error: ISO C++ forbids declaration of ‘Persistent’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:49: error: expected ‘;’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:59: error: ‘v8’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/executeBaton.h:59: error: expected ‘,’ or ‘...’ before ‘<’ token In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.cpp:3: /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:16: error: ‘node’ is not a namespace-name /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:16: error: expected namespace-name before ‘;’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:17: error: ‘v8’ is not a namespace-name /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:17: error: expected namespace-name before ‘;’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:19: error: expected class-name before ‘{’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:21: error: ‘Handle’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:21: error: expected ‘,’ or ‘...’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:22: error: ISO C++ forbids declaration of ‘Handle’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:22: error: expected ‘;’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:23: error: ISO C++ forbids declaration of ‘Handle’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:23: error: expected ‘;’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:24: error: ISO C++ forbids declaration of ‘Handle’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:24: error: expected ‘;’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:25: error: ISO C++ forbids declaration of ‘Handle’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:25: error: expected ‘;’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:26: error: ISO C++ forbids declaration of ‘Handle’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:26: error: expected ‘;’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:27: error: ISO C++ forbids declaration of ‘Handle’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:27: error: expected ‘;’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:28: error: ISO C++ forbids declaration of ‘Persistent’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:28: error: expected ‘;’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:29: error: ‘uv_work_t’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:30: error: ‘uv_work_t’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:31: error: ‘uv_work_t’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:32: error: ‘uv_work_t’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:33: error: ‘uv_work_t’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:34: error: ‘uv_work_t’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:47: error: ISO C++ forbids declaration of ‘Local’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:47: error: expected ‘;’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:48: error: ISO C++ forbids declaration of ‘Local’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/connection.h:48: error: expected ‘;’ before ‘<’ token In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.cpp:4: /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:12: error: ‘node’ is not a namespace-name /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:12: error: expected namespace-name before ‘;’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:13: error: ‘v8’ is not a namespace-name /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:13: error: expected namespace-name before ‘;’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:15: error: expected class-name before ‘{’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:17: error: ‘Handle’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:17: error: expected ‘,’ or ‘...’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:18: error: ISO C++ forbids declaration of ‘Handle’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:18: error: expected ‘;’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:19: error: ISO C++ forbids declaration of ‘Persistent’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:19: error: expected ‘;’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.cpp:6: error: expected constructor, destructor, or type conversion before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.cpp:10: error: ISO C++ forbids declaration of ‘Persistent’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.cpp:10: error: expected ‘;’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.cpp:22: error: variable or field ‘Init’ declared void /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.cpp:22: error: ‘Handle’ was not declared in this scope /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.cpp:22: error: ‘Object’ was not declared in this scope /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.cpp:22: error: ‘target’ was not declared in this scope /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.cpp:35: error: expected constructor, destructor, or type conversion before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/oracle_bindings.cpp:51: error: expected constructor, destructor, or type conversion before ‘<’ token [4/5] cxx: src/outParam.cpp -> build/Release/src/outParam.o In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.cpp:2: /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:5:16: error: v8.h: No such file or directory /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:6:18: error: node.h: No such file or directory In file included from /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.cpp:2: /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:12: error: ‘node’ is not a namespace-name /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:12: error: expected namespace-name before ‘;’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:13: error: ‘v8’ is not a namespace-name /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:13: error: expected namespace-name before ‘;’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:15: error: expected class-name before ‘{’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:17: error: ‘Handle’ has not been declared /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:17: error: expected ‘,’ or ‘...’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:18: error: ISO C++ forbids declaration of ‘Handle’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:18: error: expected ‘;’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:19: error: ISO C++ forbids declaration of ‘Persistent’ with no type /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.h:19: error: expected ‘;’ before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.cpp:4: error: expected constructor, destructor, or type conversion before ‘<’ token /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.cpp:6: error: variable or field ‘Init’ declared void /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.cpp:6: error: ‘Handle’ was not declared in this scope /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.cpp:6: error: ‘Object’ was not declared in this scope /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.cpp:6: error: ‘target’ was not declared in this scope /Volumes/Kuky_Doc/projects/Actbook/node_modules/oracle/src/outParam.cpp:17: error: expected constructor, destructor, or type conversion before ‘<’ token ERROR: [Error: At least one file failed to compile.] npm ERR! [email protected] install:node mnm.js build npm ERR!sh "-c" "node mnm.js build"` failed with 1
npm ERR!
npm ERR! Failed at the [email protected] install script.
npm ERR! This is most likely a problem with the oracle package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR! node mnm.js build
npm ERR! You can get their info via:
npm ERR! npm owner ls oracle
npm ERR! There is likely additional logging output above.

npm ERR! System Darwin 12.3.0
npm ERR! command "/Volumes/Kuky_Doc/dev/node-v0.10.2-darwin-x64/bin/node" "/Volumes/Kuky_Doc/dev/node-v0.10.2-darwin-x64/bin/npm" "install" "oracle"
npm ERR! cwd /Volumes/Kuky_Doc/projects/Actbook
npm ERR! node -v v0.10.2
npm ERR! npm -v 1.2.15
npm ERR! code ELIFECYCLE
npm ERR!
npm ERR! Additional logging details can be found in:
npm ERR! /Volumes/Kuky_Doc/projects/Actbook/npm-debug.log
npm ERR! not ok code 0

thoroughly document connection parameters

Issues #44 and #24 (and perhaps even #47) both have the same basic cause: missing documentation of the connection parameters in different scenarios.

What is working: using hostname, port and SID.

Is the name in tnsnames.ora also working? How would the parameters have to be set?

To reduce the number of issues, a more detailed documentation would really be great. I could try (by trial and error) to reverse engineer the possible values, but if someone with a more thorough kowledge of the code and the different connection paramters would step in, I would very much prefer that ...

ORA-12154: TNS:could not resolve the connect identifier specified

Here is the code:

var oracle = require("oracle");
var conData = {
    tns:    '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=mysid)))',
    user:   'myname',
    password: 'mypass'
};
oracle.connect(conData, function(err, con){
    if (err)
        console.log('ERROR', err);
    else
        console.log('OK', con);
});

And I get:

ERROR [Error: ORA-12154: TNS:could not resolve the connect identifier specified]

Connection data is correct. I have php installed with oci extension and it connects with the same copypasted connection string, username and password. SQLPlus also works.

I also tried to use:

• an object with "hostname" and "database" properties instead of "tns",
• easy connect string,
• reference to tnsnames.ora,
• random strings in all properties, like @#$%^&*(,
• empty object { }.

I see the same error 12154 in each case, no matter what data I put in the conData variable.

Some info about my environment:

ORACLE_HOME=/usr/lib/oracle/11.2/client64
OCI_INCLUDE_DIR=/usr/include/oracle/11.2/client64
OCI_LIB_DIR=/usr/lib/oracle/11.2/client64/lib
TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin

$ uname -rvio
3.8.0-21-generic #32-Ubuntu SMP Tue May 14 22:16:46 UTC 2013 x86_64 GNU/Linux

$ node --version
v0.10.12

Thanks!

Error invalid characters

var oracle = require('oracle')
var connectData = { PORT: 1521, hostname: "localhost", user: "hr", password: "hr", database: "xe"
};

console.log('Connecting');

oracle.connect(connectData, function(err, connection) {
if(err) {
console.log(err);
}

  if(connection!=undefined) {
    console.log('connected');
  }

});

Output:

I get invalid characters while logging the error and the connection object is undefined.

C:\Program Files (x86)\nodejs>node.exe testdb.js
Connecting
Error: P♂Y♥(►Y♥8☺Y♥~?▬

Enhancement request: Detect if/when the connection drops

Once a connection to Oracle is made, I would like to be able to know if the connection is lost for any reason other than when connection.close is executed. It would be helpful to have some sort of connection dropped event. It would also be nice to have an optional auto reconnect feature.

Errors with oracle 10.2

Distributor ID: RedHatEnterpriseServer
Release: 5.5

node -v
v0.8.15

Oracle 10.2.0.3.0

var oracle = require("oracle");

oracle.connect({ "hostname": "localhost", "user": "rvillarta",
"password": "password", "database":"rv", "port":1543 }, function(err, connection) {
// selecting rows
connection.execute("SELECT 'hello' FROM dual", [], function(err, results) {
});
// results will be an array of objects
});

*** glibc detected *** node: free(): invalid pointer: 0x0000000003cf4480 ***
======= Backtrace: =========
/lib64/libc.so.6[0x325cc7230f]
/lib64/libc.so.6(cfree+0x4b)[0x325cc7276b]
/usr/lib64/libstdc++.so.6(_ZNSsD1Ev+0x3a)[0x333d49dbca]
/home/r.villarta/test/node_modules/oracle/build/Release/oracle_bindings.node(_ZN12ExecuteBatonD1Ev+0x23e)[0x2aaaaaba1110]
/home/r.villarta/test/node_modules/oracle/build/Release/oracle_bindings.node(_ZN10Connection16EIO_AfterExecuteEP9uv_work_s+0x491)[0x2aaaaaba42a3]
node[0x5e082f]
node[0x5d6bf4]
node(eio_poll+0xc3)[0x5d7033]
node[0x5e8148]
node[0x5d569a]
node(ev_invoke_pending+0x66)[0x5da256]
node[0x5d5e80]
node(uv_run+0xc)[0x5d60fc]
node(_ZN4node5StartEiPPc+0x174)[0x5897d4]
/lib64/libc.so.6(__libc_start_main+0xf4)[0x325cc1d994]
node(cos+0x101)[0x582529]
======= Memory map: ========
00400000-00bea000 r-xp 00000000 08:07 459038 /home/r.villarta/node-v0.8.15/bin/node
00dea000-00dfd000 rwxp 007ea000 08:07 459038 /home/r.villarta/node-v0.8.15/bin/node
00dfd000-00e08000 rwxp 00dfd000 00:00 0
03c59000-03d9a000 rwxp 03c59000 00:00 0 [heap]
40649000-4064a000 ---p 40649000 00:00 0
4064a000-4068a000 rwxp 4064a000 00:00 0
411db000-411dc000 ---p 411db000 00:00 0
411dc000-411ec000 rwxp 411dc000 00:00 0
325c800000-325c81c000 r-xp 00000000 08:03 1295375 /lib64/ld-2.5.so
325ca1b000-325ca1c000 r-xp 0001b000 08:03 1295375 /lib64/ld-2.5.so
325ca1c000-325ca1d000 rwxp 0001c000 08:03 1295375 /lib64/ld-2.5.so
325cc00000-325cd4e000 r-xp 00000000 08:03 1295384 /lib64/libc-2.5.so
325cd4e000-325cf4d000 ---p 0014e000 08:03 1295384 /lib64/libc-2.5.so
325cf4d000-325cf51000 r-xp 0014d000 08:03 1295384 /lib64/libc-2.5.so
325cf51000-325cf52000 rwxp 00151000 08:03 1295384 /lib64/libc-2.5.so
325cf52000-325cf57000 rwxp 325cf52000 00:00 0
325d000000-325d082000 r-xp 00000000 08:03 1295570 /lib64/libm-2.5.so
325d082000-325d281000 ---p 00082000 08:03 1295570 /lib64/libm-2.5.so
325d281000-325d282000 r-xp 00081000 08:03 1295570 /lib64/libm-2.5.so
325d282000-325d283000 rwxp 00082000 08:03 1295570 /lib64/libm-2.5.so
325d400000-325d402000 r-xp 00000000 08:03 1295559 /lib64/libdl-2.5.so
325d402000-325d602000 ---p 00002000 08:03 1295559 /lib64/libdl-2.5.so
325d602000-325d603000 r-xp 00002000 08:03 1295559 /lib64/libdl-2.5.so
325d603000-325d604000 rwxp 00003000 08:03 1295559 /lib64/libdl-2.5.so
325d800000-325d816000 r-xp 00000000 08:03 1295429 /lib64/libpthread-2.5.so
325d816000-325da15000 ---p 00016000 08:03 1295429 /lib64/libpthread-2.5.so
325da15000-325da16000 r-xp 00015000 08:03 1295429 /lib64/libpthread-2.5.so
325da16000-325da17000 rwxp 00016000 08:03 1295429 /lib64/libpthread-2.5.so
325da17000-325da1b000 rwxp 325da17000 00:00 0
325e000000-325e007000 r-xp 00000000 08:03 1295540 /lib64/librt-2.5.so
325e007000-325e207000 ---p 00007000 08:03 1295540 /lib64/librt-2.5.so
325e207000-325e208000 r-xp 00007000 08:03 1295540 /lib64/librt-2.5.so
325e208000-325e209000 rwxp 00008000 08:03 1295540 /lib64/librt-2.5.so
3260c00000-3260c15000 r-xp 00000000 08:03 1295553 /lib64/libnsl-2.5.so
3260c15000-3260e14000 ---p 00015000 08:03 1295553 /lib64/libnsl-2.5.so
3260e14000-3260e15000 r-xp 00014000 08:03 1295553 /lib64/libnsl-2.5.so
3260e15000-3260e16000 rwxp 00015000 08:03 1295553 /lib64/libnsl-2.5.so
3260e16000-3260e18000 rwxp 3260e16000 00:00 0
333d000000-333d00d000 r-xp 00000000 08:03 1295373 /lib64/libgcc_s-4.1.2-20080825.so.1
333d00d000-333d20d000 ---p 0000d000 08:03 1295373 /lib64/libgcc_s-4.1.2-20080825.so.1
333d20d000-333d20e000 rwxp 0000d000 08:03 1295373 /lib64/libgcc_s-4.1.2-20080825.so.1
333d400000-333d4e6000 r-xp 00000000 08:05 1393773 /usr/lib64/libstdc++.so.6.0.8
333d4e6000-333d6e5000 ---p 000e6000 08:05 1393773 /usr/lib64/libstdc++.so.6.0.8
333d6e5000-333d6eb000 r-xp 000e5000 08:05 1393773 /usr/lib64/libstdc++.so.6.0.8
333d6eb000-333d6ee000 rwxp 000eb000 08:05 1393773 /usr/lib64/libstdc++.so.6.0.8
333d6ee000-333d700000 rwxp 333d6ee000 00:00 0
93e3052000-93e3053000 r-xp 93e3052000 00:00 0
418ccb7c000-418ccb7d000 r-xp 418ccb7c000 00:00 0
d6cf9100000-d6cf911d000 rwxp d6cf9100000 00:00 0
d91473d9000-d91473da000 r-xp d91473d9000 00:00 0
118229496000-118229497000 r-xp 118229496000 00:00 0
12e30a800000-12e30a900000 rwxp 12e30a800000 00:00 0
1e084684b000-1e0846880000 ---p 1e084684b000 00:00 0
1e0846880000-1e08468a0000 rwxp 1e0846880000 00:00 0
1e08468a0000-1e08468ab000 ---p 1e08468a0000 00:00 0
1e7987368000-1e7987369000 rwxp 1e7987368000 00:00 0
1e7987369000-1e7987568000 ---p 1e7987369000 00:00 0
2aaaaaaad000-2aaaaaae2000 r-xs 00000000 08:06 582918 /var/db/nscd/hosts
2aaaaab0d000-2aaaaab8e000 rwxp 2aaaaab0d000 00:00 0
2aaaaab8e000-2aaaaabaf000 r-xp 00000000 08:07 165792 /home/r.villarta/test/node_modules/oracle/build/Release/oracle_bindings.node
2aaaaabaf000-2aaaaadae000 ---p 00021000 08:07 165792 /home/r.villarta/test/node_modules/oracle/build/Release/oracle_bindings.node
2aaaaadae000-2aaaaadb0000 rwxp 00020000 08:07 165792 /home/r.villarta/test/node_modules/oracle/build/Release/oracle_bindings.node
2aaaaadb0000-2aaaaaeab000 r-xp 00000000 08:03 1295925 /u01/app/oracle/product/client/10.2.0/lib/libocci.so.10.1
2aaaaaeab000-2aaaaafab000 ---p 000fb000 08:03 1295925 /u01/app/oracle/product/client/10.2.0/lib/libocci.so.10.1
2aaaaafab000-2aaaaafd8000 rwxp 000fb000 08:03 1295925 /u01/app/oracle/product/client/10.2.0/lib/libocci.so.10.1
2aaaaafd8000-2aaaac1e9000 r-xp 00000000 08:03 1295964 /u01/app/oracle/product/client/10.2.0/lib/libclntsh.so.10.1
2aaaac1e9000-2aaaac3e9000 ---p 01211000 08:03 1295964 /u01/app/oracle/product/client/10.2.0/lib/libclntsh.so.10.1
2aaaac3e9000-2aaaac48c000 rwxp 01211000 08:03 1295964 /u01/app/oracle/product/client/10.2.0/lib/libclntsh.so.10.1
2aaaac48c000-2aaaac49f000 rwxp 2aaaac48c000 00:00 0
2aaaac49f000-2aaaac791000 r-xp 00000000 08:03 1295955 /u01/app/oracle/product/client/10.2.0/lib/libnnz10.so
2aaaac791000-2aaaac890000 ---p 002f2000 08:03 1295955 /u01/app/oracle/product/client/10.2.0/lib/libnnz10.so
2aaaac890000-2aaaac941000 rwxp 002f1000 08:03 1295955 /u01/app/oracle/product/client/10.2.0/lib/libnnz10.so
2aaaac941000-2aaaac942000 rwxp 2aaaac941000 00:00 0
2aaaac953000-2aaaaca14000 r-xp 00000000 08:05 1394168 /usr/lib64/libstdc++.so.5.0.7
2aaaaca14000-2aaaacc14000 ---p 000c1000 08:05 1394168 /usr/lib64/libstdc++.so.5.0.7
2aaaacc14000-2aaaacc1d000 rwxp 000c1000 08:05 1394168 /usr/lib64/libstdc++.so.5.0.7
2aaaacc1d000-2aaaacc2e000 rwxp 2aaaacc1d000 00:00 0
2aaaacc2e000-2aaaacc91000 r-xp 00000000 08:03 1457441 /u01/app/oracle/product/client/10.2.0/oracore/zoneinfo/timezlrg.dat
2aaaacc91000-2aaaaccc6000 r-xs 00000000 08:06 582914 /var/db/nscd/passwd
2af36b230000-2af36b231000 rwxp 2af36b230000 00:00 0
2af36b242000-2af36b247000 rwxp 2af36b242000 00:00 0
2c9b41300000-2c9b41385000 rwxp 2c9b41300000 00:00 0
2cf8abdb4000-2cf8abe00000 ---p 2cf8abdb4000 00:00 0
2cf8abe00000-2cf8abe05000 rwxp 2cf8abe00000 00:00 0
2cf8abe05000-2cf8abe06000 ---p 2cf8abe05000 00:00 0
2cf8abe06000-2cf8abeff000 rwxp 2cf8abe06000 00:00 0
2cf8abeff000-2cf8cbdb4000 ---p 2cf8abeff000 00:00 0
307baa000000-307baaf00000 ---p 307baa000000 00:00 0
307baaf00000-307bab000000 rwxp 307baaf00000 00:00 0
307bab000000-307bac000000 ---p 307bab000000 00:00 0
352532796000-352532797000 r-xp 352532796000 00:00 0
383187500000-383187525000 rwxp 383187500000 00:00 0
3ee566700000-3ee566735000 rwxp 3ee566700000 00:00 0
7fff8a551000-7fff8a566000 rwxp 7ffffffea000 00:00 0 [stack]
ffffffffff600000-ffffffffffe00000 ---p 00000000 00:00 0 [vdso]
Aborted

npm install oracle fails on mnm.js

I am using a new install of nodev0.8.6. Doing a technology spike on Nodejs and Oracle possibilities. I have downloaded the basiclite and sdk and have exported the appropriate env vars (at first I didn't and I was getting different errors).

During step 4/5 I get the following error:

ERROR: [Error: At least one file failed to compile.]
npm ERR! [email protected] install: `node mnm.js build`
npm ERR! `sh "-c" "node mnm.js build"` failed with 1
npm ERR! 
npm ERR! Failed at the [email protected] install script.
npm ERR! This is most likely a problem with the oracle package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR!     node mnm.js build
npm ERR! You can get their info via:
npm ERR!     npm owner ls oracle
npm ERR! There is likely additional logging output above.

npm ERR! System Linux 3.2.0-23-generic
npm ERR! command "/usr/local/bin/node" "/usr/local/bin/npm" "install" "oracle"
npm ERR! cwd /home/aaron/source/test/node-oracle-driver
npm ERR! node -v v0.8.6
npm ERR! npm -v 1.1.48
npm ERR! code ELIFECYCLE
npm ERR! 
npm ERR! Additional logging details can be found in:
npm ERR!     /home/aaron/source/test/node-oracle-driver/npm-debug.log
npm ERR! not ok code 0

Not sure what to do next. Please help.

Concerns about the way node-oracle handles cursors in results from stored procs

While reviewing the C++ code for my previous issue #61, I noticed that when a stored proc returns a cursor the node-oracle code in connection.cpp automatically iterates over the results and builds an array of all results. This is fine for smaller datasets and even datasets with thousands or tens of thousands of results, but it would be a problem for any stored proc returning millions of rows.

My guess is that the cursors are hidden from node.js for simplicity reasons. But this eventually going to blow up in someone's face. It would be awesome to have a second method for calling a stored proc that returns a cursor to pass some object representing the cursor back to calling node.js code and allow the node.js programmer to then iterate over the results.

While I will most like use the fork I made today to fix my problems in issue 61, I doubt I will have time to tackle the results cursor. Has anyone ever encountered a problem with the returned array? As I've mentioned I am doing work for a very large media company. There are certainly values that we may query from node.js that could approach a million rows!

Installation: mnm.js build fails on node v0.8.12

Hi,

I'm trying to start a project with oracle backend and really appreciate any help on this subject matter.

I wonder if the version of node v0.8.12 is compatible with node-oracle as the installation fails with the following error:

npm install oracle
npm http GET https://registry.npmjs.org/oracle
npm http 304 https://registry.npmjs.org/oracle
npm http GET https://registry.npmjs.org/mnm
npm http 304 https://registry.npmjs.org/mnm

[email protected] install /home/test/node_modules/oracle
node mnm.js build

path.existsSync is now called fs.existsSync.
[1/5] cxx: src/oracle_bindings.cpp -> build/Release/src/oracle_bindings.o
/home/test/node_modules/oracle/src/oracle_bindings.cpp: In static member function ‘static v8::Handlev8::Value OracleClient::Connect(const v8::Arguments&)’:
/home/test/node_modules/oracle/src/oracle_bindings.cpp:74:27: error: cannot convert ‘uv_loop_t* {aka uv_loop_s_}’ to ‘uv_handle_t_ {aka uv_handle_s_}’ for argument ‘1’ to ‘void uv_ref(uv_handle_t_)’
/home/test/node_modules/oracle/src/oracle_bindings.cpp: In static member function ‘static void OracleClient::EIO_AfterConnect(uv_work_t_)’:
/home/test/node_modules/oracle/src/oracle_bindings.cpp:96:29: error: cannot convert ‘uv_loop_t_ {aka uv_loop_s_}’ to ‘uv_handle_t_ {aka uv_handle_s_}’ for argument ‘1’ to ‘void uv_unref(uv_handle_t_)’
[2/5] cxx: src/outParam.cpp -> build/Release/src/outParam.o
[3/5] cxx: src/connection.cpp -> build/Release/src/connection.o
/home/test/node_modules/oracle/src/connection.cpp: In static member function ‘static v8::Handlev8::Value Connection::Execute(const v8::Arguments&)’:
/home/test/node_modules/oracle/src/connection.cpp:66:27: error: cannot convert ‘uv_loop_t* {aka uv_loop_s_}’ to ‘uv_handle_t_ {aka uv_handle_s_}’ for argument ‘1’ to ‘void uv_ref(uv_handle_t_)’
/home/test/node_modules/oracle/src/connection.cpp: In static member function ‘static v8::Handlev8::Value Connection::Commit(const v8::Arguments&)’:
/home/test/node_modules/oracle/src/connection.cpp:99:27: error: cannot convert ‘uv_loop_t* {aka uv_loop_s_}’ to ‘uv_handle_t_ {aka uv_handle_s_}’ for argument ‘1’ to ‘void uv_ref(uv_handle_t_)’
/home/test/node_modules/oracle/src/connection.cpp: In static member function ‘static v8::Handlev8::Value Connection::Rollback(const v8::Arguments&)’:
/home/test/node_modules/oracle/src/connection.cpp:125:27: error: cannot convert ‘uv_loop_t* {aka uv_loop_s_}’ to ‘uv_handle_t_ {aka uv_handle_s_}’ for argument ‘1’ to ‘void uv_ref(uv_handle_t_)’
/home/test/node_modules/oracle/src/connection.cpp: In static member function ‘static void Connection::EIO_AfterCommit(uv_work_t_)’:
/home/test/node_modules/oracle/src/connection.cpp:265:29: error: cannot convert ‘uv_loop_t_ {aka uv_loop_s_}’ to ‘uv_handle_t_ {aka uv_handle_s_}’ for argument ‘1’ to ‘void uv_unref(uv_handle_t_)’
/home/test/node_modules/oracle/src/connection.cpp: In static member function ‘static void Connection::EIO_AfterRollback(uv_work_t_)’:
/home/test/node_modules/oracle/src/connection.cpp:283:29: error: cannot convert ‘uv_loop_t_ {aka uv_loop_s_}’ to ‘uv_handle_t_ {aka uv_handle_s_}’ for argument ‘1’ to ‘void uv_unref(uv_handle_t_)’
/home/test/node_modules/oracle/src/connection.cpp: In static member function ‘static void Connection::EIO_AfterExecute(uv_work_t_)’:
/home/test/node_modules/oracle/src/connection.cpp:445:29: error: cannot convert ‘uv_loop_t_ {aka uv_loop_s_}’ to ‘uv_handle_t_ {aka uv_handle_s_}’ for argument ‘1’ to ‘void uv_unref(uv_handle_t_)’

[4/5] cxx: src/executeBaton.cpp -> build/Release/src/executeBaton.o
ERROR: [Error: At least one file failed to compile.]
npm ERR! [email protected] install: node mnm.js build
npm ERR! sh "-c" "node mnm.js build" failed with 1
npm ERR!
npm ERR! Failed at the [email protected] install script.
npm ERR! This is most likely a problem with the oracle package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR! node mnm.js build
npm ERR! You can get their info via:
npm ERR! npm owner ls oracle
npm ERR! There is likely additional logging output above.

npm ERR! System Linux 3.2.0-32-generic
npm ERR! command "node" "/usr/local/bin/npm" "install" "oracle"
npm ERR! cwd /home/test
npm ERR! node -v v0.8.12
npm ERR! npm -v 1.1.65
npm ERR! code ELIFECYCLE
npm ERR!
npm ERR! Additional logging details can be found in:
npm ERR! /home/test/npm-debug.log
npm ERR! not ok code 0

---

Kind regards,

Ari

Error : ORA-21561 OID generation failed

i had this error message
how can i solve that ?

Error : ORA-21561 OID generation failed

OCI_INCLUDE_DIR="/opt/instantclient/sdk/include/"
OCI_LIB_DIR="/opt/instantclient"
ORACLE_HOME="/opt/instantclient"

$ uname -a
Linux xxxxxx2.6.18-348.4.1.el5 #1 SMP Fri Mar 22 05:41:51 EDT 2013 x86_64 x86_64 x86_64 GNU/Linux

$ cat /etc/issue
Red Hat Enterprise Linux Server release 5.9 (Tikanga)
Kernel \r on an \m

$ gcc --version
gcc (GCC) 4.6.2
Copyright (C) 2011 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

64 bit architecture issue

i'm on OSX 10.8.3 and i downloaded, configured, and installed the following:

instantclient-sdk-macos.x64-11.2.0.3.0.zip
instantclient-sqlplus-macos.x64-11.2.0.3.0.zip
instantclient-basic-macos.x64-11.2.0.3.0.zip

.bash_profile
export ORACLE_HOME=/usr/instantclient_11_2/
export DYLD_LIBRARY_PATH=$ORACLE_HOME
export SQLPATH=$ORACLE_HOME
export PATH=$PATH:$ORACLE_HOME
export LD_LIBRARY_PATH=$ORACLE_HOME
export OCI_INCLUDE_DIR=/usr/instantclient_11_2/sdk/include/
export OCI_LIB_DIR=/usr/instantclient_11_2/
export NODE_PATH=/usr/local/lib/node_modules/

i'm getting the following error. is this not compatible with the x64 instant client?
Checking for header occi.h
==>

include <occi.h>

int main() {
return 0;
}

<==
[1/2] �[32mcxx: build/.conf_check_0/test.cpp -> build/.conf_check_0/testbuild/Release/test_1.o
�[0m['/usr/bin/g++', '-g', '-Wall', '-I/usr/instantclient_11_2/sdk/include/', '../test.cpp', '-c', '-o', 'Release/test_1.o']
[2/2] �[33mcxx_link: build/.conf_check_0/testbuild/Release/test_1.o -> build/.conf_check_0/testbuild/Release/testprog
�[0mld: warning: ld: warning: ld: warning: ignoring file Release/test_1.o, file was built for unsupported file format ( 0xcf 0xfa 0xed 0xfe 0x 7 0x 0 0x 0 0x 1 0x 3 0x 0 0x 0 0x 0 0x 1 0x 0 0x 0 0x 0 ) which is not the architecture being linked (i386): Release/test_1.oignoring file /usr/instantclient_11_2//libclntsh.dylib, file was built for unsupported file format ( 0xcf 0xfa 0xed 0xfe 0x 7 0x 0 0x 0 0x 1 0x 3 0x 0 0x 0 0x 0 0x 6 0x 0 0x 0 0x 0 ) which is not the architecture being linked (i386): /usr/instantclient_11_2//libclntsh.dylibignoring file /usr/instantclient_11_2//libocci.dylib, file was built for unsupported file format ( 0xcf 0xfa 0xed 0xfe 0x 7 0x 0 0x 0 0x 1 0x 3 0x 0 0x 0 0x 0 0x 6 0x 0 0x 0 0x 0 ) which is not the architecture being linked (i386): /usr/instantclient_11_2//libocci.dylib

ld: warning: ignoring file /usr/instantclient_11_2//libnnz11.dylib, file was built for unsupported file format ( 0xcf 0xfa 0xed 0xfe 0x 7 0x 0 0x 0 0x 1 0x 3 0x 0 0x 0 0x 0 0x 6 0x 0 0x 0 0x 0 ) which is not the architecture being linked (i386): /usr/instantclient_11_2//libnnz11.dylib
Undefined symbols for architecture i386:
"_main", referenced from:
start in crt1.10.6.o
ld: symbol(s) not found for architecture i386
collect2: ld returned 1 exit status
['/usr/bin/g++', 'Release/test_1.o', '-o', '/Users/akume/Documents/Work/baseD8ta/node_modules/oracle/build/.conf_check_0/testbuild/Release/testprog', '-arch', 'i386', '-L/usr/instantclient_11_2/', '-locci', '-lclntsh', '-lnnz11']
command returned 'Build failed: -> task failed (err #1): \n\t{task: cxx_link test_1.o -> testprog}'Missing include files for OCI

Building on OS X 10.7+

The Oracle "Instantclient" 64Bit gives (gave) a segmentation fault (see #1). There is a new version available, that still has some other problems, but we should track that progress:

https://forums.oracle.com/forums/thread.jspa?messageID=10836929

(Last checked on Feb. 19th)

NOT able to install oracle pkg

[email protected] install /usr/lib/node_modules/oracle

node mnm.js build

[1/5] cxx: src/connection.cpp -> build/Release/src/connection.o
In file included from /usr/lib/node_modules/oracle/src/connection.cpp:2:0:
/usr/lib/node_modules/oracle/src/connection.h:5:16: fatal error: v8.h: No such file or directory
compilation terminated.
[2/5] cxx: src/executeBaton.cpp -> build/Release/src/executeBaton.o
In file included from /usr/lib/node_modules/oracle/src/executeBaton.cpp:2:0:
/usr/lib/node_modules/oracle/src/executeBaton.h:7:16: fatal error: v8.h: No such file or directory
compilation terminated.
[3/5] cxx: src/oracle_bindings.cpp -> build/Release/src/oracle_bindings.o
In file included from /usr/lib/node_modules/oracle/src/oracle_bindings.cpp:2:0:
/usr/lib/node_modules/oracle/src/oracle_bindings.h:5:16: fatal error: v8.h: No such file or directory
compilation terminated.
[4/5] cxx: src/outParam.cpp -> build/Release/src/outParam.o
In file included from /usr/lib/node_modules/oracle/src/outParam.cpp:2:0:
/usr/lib/node_modules/oracle/src/outParam.h:5:16: fatal error: v8.h: No such file or directory
compilation terminated.
ERROR: [Error: At least one file failed to compile.]
npm ERR! [email protected] install: node mnm.js build
npm ERR! sh "-c" "node mnm.js build" failed with 1
npm ERR!
npm ERR! Failed at the [email protected] install script.
npm ERR! This is most likely a problem with the oracle package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR! node mnm.js build
npm ERR! You can get their info via:
npm ERR! npm owner ls oracle
npm ERR! There is likely additional logging output above.

How can i config character set

My database default character set is ZHS16GBK

How can i get right format fields ?

Uncaught TypeError: Cannot call method 'execute' of undefined

hi nearinfinity,

I have some issues here. I tried to run the code as show below:

var oracle = require("oracle");

oracle.connect({ "hostname": "122.248.236.106", "username": "Rain_Data", "password": "oracle" }, function(err, connection) {
// selecting rows
connection.execute("SELECT * FROM networks", function(err, results) {
console.dir(results);
});

connection.setAutoCommit(true);

connection.commit(function(err) {
console.dir(err);
});

connection.rollback(function(err) {
// transaction rolledback
});

connection.close(); // call this when you are done with the connection
});

it gives this error "/home/risto/NetBeansProjects/AdNode/test/testOracleConnection.js:253: Uncaught TypeError: Cannot call method 'execute' of undefined"

Please help. I am using Oracle 11g. Thanks

Crash on windows

I compile it, but it crash on:

OracleClient::OracleClient() {
  m_environment = oracle::occi::Environment::createEnvironment(oracle::occi::Environment::THREADED_UNMUTEXED);
}

without any errors.

Even I try to modify it to:

 OracleClient::OracleClient() {
   try {
     m_environment = oracle::occi::Environment::createEnvironment(oracle::occi::Environment::THREADED_UNMUTEXED);
   } catch(oracle::occi::SQLException &ex) {
     std::cout << new std::string(ex.getMessage());
   }
 }

I get address, not string message.

ORA-24338 statement handle not executed

Environment: Arch Linux (within Virtual Box on Windows 7)
Node: v0.10.15
Instant client: 12.1.0.1.0 (fresh version)

After successful install of oracle node module i wrote a sample script with just one select from view (simple view, contains about 300 rows). When i tried to run that script using node got the following error:

[Error: ORA-24338: statement handle not executed]

When I 'select * from dual' or 'select * ... where rownum < 2', no errors arise

statement cache

if you add this at line 87 in oracle_bindings it speeds things up by about 30% on my setup. this allows you to avoid having to compile the sql in the client every time you execute:

baton->connection->setStmtCacheSize(100);

https://github.com/nearinfinity/node-oracle/blob/master/src/oracle_bindings.cpp#L87

i can submit a patch if you like.

Error in npm install node-oracle with solving (nodejs 0.10.0, CentOS 6.4 64bit)

Hello,
I'm oracle guy, I try to configure nodejs for oracle.
I use your way, but I still get error no occi.h found. I try some 11.2g versions of Oracle, no solve...when I trace write script, I found use this hint for use library '-lnnz10'. (I'm not C programmer...)
This is a problem...because Oracle client doesn't contain library libnnz10.so, but libnnz11.so. When I try use ln -s libnnz11.so libnnz10.so, I solve this problem.

int main() {
return 0;
}

<==
[1/2] ^[[32mcxx: build/.conf_check_0/test.cpp -> build/.conf_check_0/testbuild/Release/test_1.o
^[[0m['/usr/bin/g++', '-g', '-Wall', '-I/usr/include/oracle/11.2/client64/', '../test.cpp', '-c', '-o', 'Release/test_1.o']
[2/2] ^[[33mcxx_link: build/.conf_check_0/testbuild/Release/test_1.o -> build/.conf_check_0/testbuild/Release/testprog
^[[0m['/usr/bin/g++', 'Release/test_1.o', '-o', '/tmp/oracle/node-oracle/build/.conf_check_0/testbuild/Release/testprog', '-L/usr/lib/oracle/11.2/client64/lib', '-locci', '-lclntsh', '-lnnz10', '-Wl,-Bdynamic']

But...when I try node-waf configure build, I got another error (I try it with node 0.10.0, but previous version get same error (0.8.*, 0.6.9), on CentOS 6.4 x64

[root@PSIMLX1 node-oracle]# node-waf configure build
Checking for program g++ or c++ : /usr/bin/g++
Checking for program cpp : /usr/bin/cpp
Checking for program ar : /usr/bin/ar
Checking for program ranlib : /usr/bin/ranlib
Checking for g++ : ok
Checking for node path : not found
Checking for node prefix : ok /usr/local
Checking for header occi.h : yes
Checking for library occi : yes
'configure' finished successfully (0.545s)
Waf: Entering directory /tmp/oracle/node-oracle/build' [1/5] cxx: src/connection.cpp -> build/Release/src/connection_1.o [2/5] cxx: src/executeBaton.cpp -> build/Release/src/executeBaton_1.o ../src/connection.cpp: In static member function ‘static v8::Local<v8::Object> Connection::CreateV8ObjectFromRow(ExecuteBaton*, row_t*)’: ../src/connection.cpp:415: error: ‘memset’ was not declared in this scope Waf: Leaving directory/tmp/oracle/node-oracle/build'
Build failed: -> task failed (err #1):
{task: cxx connection.cpp -> connection_1.o}

I thing, that problem is with using another version of library (use 11th version not 10.2 version)

Thank for your response

error while installing oracle on win7 64bit with node0.10.5 64bit

I clone the repository zip file, then unzip it to E:\nodejs\chat\node_modules\oracle.

but when npm install, i got some error like this:

   E:\nodejs\chat\node_modules\oracle>npm install

> [email protected] install E:\nodejs\chat\node_modules\oracle
> node-gyp rebuild


E:\nodejs\chat\node_modules\oracle>node "C:\Program Files\nodejs\node_modules\npm\bin\node-gyp-bin\\..\..\node_modules\node-
gyp\bin\node-gyp.js" rebuild
在此解决方案中一次生成一个项目。若要启用并行生成，请添加“/m”开关。
C:\Program Files (x86)\MSBuild\Microsoft.Cpp\v4.0\Microsoft.Cpp.InvalidPlatform.Targets(23,7): error MSB8007: 项目“oracle_b
in
dings.vcxproj”的平台无效。平台为“x64”。您会看到此消息的可能原因是，您尝试在没有解决方案文件的情况下生成项目，并且为此项目
指定了并不存在的非默认平台。 [E:\nodejs\chat\node_modules\oracle\bu
ild\oracle_bindings.vcxproj]
gyp ERR! build error
gyp ERR! stack Error: `C:\Windows\Microsoft.NET\Framework\v4.0.30319\msbuild.exe` failed with exit code: 1
gyp ERR! stack     at ChildProcess.onExit (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\build.js:267:2
3)
gyp ERR! stack     at ChildProcess.EventEmitter.emit (events.js:98:17)
gyp ERR! stack     at Process.ChildProcess._handle.onexit (child_process.js:784:12)
gyp ERR! System Windows_NT 6.1.7601
gyp ERR! command "node" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "rebuild"
gyp ERR! cwd E:\nodejs\chat\node_modules\oracle
gyp ERR! node -v v0.10.5
gyp ERR! node-gyp -v v0.9.5
gyp ERR! not ok
npm ERR! [email protected] install: `node-gyp rebuild`
npm ERR! `cmd "/c" "node-gyp rebuild"` failed with 1
npm ERR!
npm ERR! Failed at the [email protected] install script.
npm ERR! This is most likely a problem with the oracle package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR!     node-gyp rebuild
npm ERR! You can get their info via:
npm ERR!     npm owner ls oracle
npm ERR! There is likely additional logging output above.

npm ERR! System Windows_NT 6.1.7601
npm ERR! command "C:\\Program Files\\nodejs\\\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\bin\\npm-cli.js" "in
stall"
npm ERR! cwd E:\nodejs\chat\node_modules\oracle
npm ERR! node -v v0.10.5
npm ERR! npm -v 1.2.18
npm ERR! code ELIFECYCLE
npm ERR!
npm ERR! Additional logging details can be found in:
npm ERR!     E:\nodejs\chat\node_modules\oracle\npm-debug.log
npm ERR! not ok code 0

Install fails when libnnzz10 isn't available

On Ubuntu, Oracle Instantclient Version 11.2.0.3.0:

> node-waf configure
...
Checking for header occi.h        : Missing include files for OCI

Cause seems to be the hardwired '-lnnzz10' in wscript:

conf.env.append_unique('LINKFLAGS', ['-locci', '-lclntsh', '-lnnz10'])

After changing it to -libnnz11, node-waf configure and node-waf build succeed.

Allow Instant Client version to be specified by user.

In binding.gyp we hardcode a version-dependent Instant Client library. The following requires Instant client v11.x:

  "libraries": [ ... "-lnnz11" ]

There should be a way for the user to specify the version number such that a simple npm install causes node-gyp to link against the correct version.

See joeferner's comment on #54 (comment)

installing on windows

C:\nodeprojects\newApp>npm install oracle
npm WARN package.json [email protected] No README.md file found!
npm http GET https://registry.npmjs.org/oracle
npm http 304 https://registry.npmjs.org/oracle

[email protected] install C:\nodeprojects\newApp\node_modules\oracle
node-gyp rebuild

C:\nodeprojects\newApp\node_modules\oracle>node "C:\Program Files\nodejs\node_mo
dules\npm\bin\node-gyp-bin....\node_modules\node-gyp\bin\node-gyp.js" rebuild

-z was unexpected at this time.
gyp: Call to 'if [ -z $OCI_LIB_DIR ]; then echo "/opt/instantclient/"; else echo
$OCI_LIB_DIR; fi' returned exit status 1. while trying to load binding.gyp
gyp ERR! configure error
gyp ERR! stack Error: gyp failed with exit code: 1
gyp ERR! stack at ChildProcess.onCpExit (C:\Program Files\nodejs\node_module
s\npm\node_modules\node-gyp\lib\configure.js:416:16)
gyp ERR! stack at ChildProcess.EventEmitter.emit (events.js:99:17)
gyp ERR! stack at Process._handle.onexit (child_process.js:678:10)
gyp ERR! System Windows_NT 6.1.7601
gyp ERR! command "node" "C:\Program Files\nodejs\node_modules\npm\node_modu
les\node-gyp\bin\node-gyp.js" "rebuild"
gyp ERR! cwd C:\nodeprojects\newApp\node_modules\oracle
gyp ERR! node -v v0.8.20
gyp ERR! node-gyp -v v0.8.4
gyp ERR! not ok
npm ERR! [email protected] install: node-gyp rebuild
npm ERR! cmd "/c" "node-gyp rebuild" failed with 1
npm ERR!
npm ERR! Failed at the [email protected] install script.
npm ERR! This is most likely a problem with the oracle package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR! node-gyp rebuild
npm ERR! You can get their info via:
npm ERR! npm owner ls oracle
npm ERR! There is likely additional logging output above.

npm ERR! System Windows_NT 6.1.7601
npm ERR! command "C:\Program Files\nodejs\node.exe" "C:\Program Files\nod
ejs\node_modules\npm\bin\npm-cli.js" "install" "oracle"
npm ERR! cwd C:\nodeprojects\newApp
npm ERR! node -v v0.8.20
npm ERR! npm -v 1.2.11
npm ERR! code ELIFECYCLE
npm ERR!
npm ERR! Additional logging details can be found in:
npm ERR! C:\nodeprojects\newApp\npm-debug.log
npm ERR! not ok code 0

libocci library doesn't load on OSX

I'm having some difficulty getting what appears to be the libocci library to load. This is what's happening:

dyld: lazy symbol binding failed: Symbol not found: __ZN6oracle4occi11Environment17createEnvironmentENS1_4ModeEPvPFS3_S3_mEPFS3_S3_S3_mEPFvS3_S3_E
Referenced from: /Users/ag/code/geotest/node_modules/oracle/build/Release/oracle_bindings.node
Expected in: dynamic lookup

dyld: Symbol not found: __ZN6oracle4occi11Environment17createEnvironmentENS1_4ModeEPvPFS3_S3_mEPFS3_S3_S3_mEPFvS3_S3_E
Referenced from: /Users/ag/code/geotest/node_modules/oracle/build/Release/oracle_bindings.node
Expected in: dynamic lookup

The library builds fine; there are no errors. This occurs when I require('oracle')

Thanks!

Windows

Is there a possibility to install node-oracle on Windows?

Thanks.

Connecting using SERVICE_NAME / SID, or via TNS

Hi,

I'm trying to figure out how to connect to an ORACLE database that has an SID specified.
I have a $TNS_ADMIN/tnsnames.ora file with a TNS alias in it, but giving oracle.connect the alias for "hostname" just results in a TNS:could not resolve the connect identifier specified.

I can pass the (physical) hostname and port as parameters, but then it complains that TNS:listener was not given the SERVICE_NAME in CONNECT_DATA. I tried passing sid: or service_name: parameters, but that had no effect.

Do you know how you can specify the service name, or use a TNS entry?

Thank you so much!
Best,
Milan

error `cmd "/c" "node mnm.js build"` failed with 1 - Windows 7 32bit

Hi,

I am getting similar errors to the other issues open but on windows 7 32 bit. I couldn't see a solution.

This is what I am getting when I run npm install oracle

Thanks

201 error [email protected] install: node mnm.js build
201 error cmd "/c" "node mnm.js build" failed with 1
202 error Failed at the [email protected] install script.
202 error This is most likely a problem with the oracle package,
202 error not with npm itself.
202 error Tell the author that this fails on your system:
202 error node mnm.js build
202 error You can get their info via:
202 error npm owner ls oracle
202 error There is likely additional logging output above.
203 error System Windows_NT 6.1.7601
204 error command "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\bin\npm-cli.js" "install" "oracle"
205 error cwd c:\www\node_loyalty_api
206 error node -v v0.10.5
207 error npm -v 1.2.18
208 error code ELIFECYCLE

Probably there is memory leak after select is executed

I use 0.3.0 version, with node 0.8.19

var oracle = require("oracle");
var memwatch = require('memwatch');

  oracle.connect({ "hostname": "..." }, function(err, connection) {

      var hd = new memwatch.HeapDiff();
      connection.execute("SELECT * FROM db_table", [], function(err, results) {
        console.log("got results from db: " + results.length);

        console.log("deallocate result manually - just to make sure that results is cleared!");
        for (var i = 0; i< results.length; i++) {
          results[i] = null;
          delete results[i];
        }

        connection.close(); // call this when you are done with the connection
        var diff = hd.end();
        console.log(JSON.stringify(diff, null, 2));
      });
    }

memwatch report:

{
    "after": {
        "nodes": 259291, 
        "size": "10.77 mb", 
        "size_bytes": 11289632, 
        "time": "2013-05-15T12:22:21.000Z"
    }, 
    "before": {
        "nodes": 137578, 
        "size": "6.52 mb", 
        "size_bytes": 6837160, 
        "time": "2013-05-15T12:22:20.000Z"
    }, 
    "change": {
        "allocated_nodes": 121786, 
        "details": [
            {
                "+": 3271, 
                "-": 22, 
                "size": "296.65 kb", 
                "size_bytes": 303768, 
                "what": "Array"
            }, 
            {
                "+": 1, 
                "-": 0, 
                "size": "72 bytes", 
                "size_bytes": 72, 
                "what": "Closure"
            }, 
            {
                "+": 125, 
                "-": 9, 
                "size": "23.07 kb", 
                "size_bytes": 23624, 
                "what": "Code"
            }, 
            {
                "+": 6228, 
                "-": 0, 
                "size": "583.88 kb", 
                "size_bytes": 597888, 
                "what": "Date"
            }, 
            {
                "+": 37380, 
                "-": 0, 
                "size": "584.06 kb", 
                "size_bytes": 598080, 
                "what": "Number"
            }, 
            {
                "+": 3122, 
                "-": 0, 
                "size": "73.17 kb", 
                "size_bytes": 74928, 
                "what": "Object"
            }, 
            {
                "+": 71647, 
                "-": 14, 
                "size": "2.73 mb", 
                "size_bytes": 2865328, 
                "what": "String"
            }
        ], 
        "freed_nodes": 73, 
        "size": "4.25 mb", 
        "size_bytes": 4452472
    }
}

Please note String allocation.
memwatch invokes gc before taking the diff of the heap, and also if you will run this code in a loop, you will see noticable leak as soon as results are pretty big.

I'm looking at the native code right now, if will be able to fix, will make a pull request.

lang encoding nodejs problem using Oracle

hello~

i've got this problem.
do you know how can i do to solve it?

Oracle Sqlplus is expressing encoding Korean normally.

this is console.log from array list
xxxxx : '?대쫫',
msg : '硫

-- oracle lang setting
$ env
NLS_LANG=American_America.KO16KSC5601

-- linux lang setting
$ echo $LANG
ko_KR.EUC-KR

$ uname -a
Linux xxxxxx2.6.18-348.4.1.el5 #1 SMP Fri Mar 22 05:41:51 EDT 2013 x86_64 x86_64 x86_64 GNU/Linux

$ cat /etc/issue
Red Hat Enterprise Linux Server release 5.9 (Tikanga)
Kernel \r on an \m

thanks !

Enhance Error handling

When I have an error connecting to Oracle I get a stack trace when the program exits. If I trap and exit the processes I get a segmentation fault.

oracle.js:378: Uncaught Error: Error: ORA-01017: invalid username/password; logon denied

Segmentation fault

If I do not exit the process and let node try to clean itself up I get the following errors followed by stack traces (trying multiple times generated multiple errors all seem related to the same thing releasing an object that doesn't appear to exist).

Uncaught Error: Error: ORA-01017: invalid username/password; logon denied

*** glibc detected *** node: free(): invalid pointer: 0x0a50e600 ***
*** glibc detected *** node: munmap_chunk(): invalid pointer: 0x0a7f2ae8 ***
*** glibc detected *** node: double free or corruption (out): 0x0892a998 ***

Sample Code

process.on('uncaughtException', function (err) {
  console.log('Caught exception: ' + err);
});

var oracle = require("oracle");

oracle.connect({ "hostname": "localhost", "user": "g", "password": "p", "database": "DB.FOO.BAR" }, function(err, connection) {
  if(err) {
    throw new Error(err);
    process.exit(1);
  }
  if(connection) { console.log(connection); }
});

I also get these errors when I run a simple select query

oracle.connect({ "hostname": "localhost", "user": "g", "password": "p", "database": "DB.FOO.BAR" }, function(err, connection) {
 function(err, connection) {
  if(err) {
    throw new Error(err);
  }
  if(connection) {
    connection.execute("select 1 from dual", [], function(err, results) {
      if(err) {
        throw new Error(err);
      }
      console.log(results);
      connection.close();
    });
  }
)};

*** glibc detected *** node: free(): invalid pointer: 0x091fa5a8 ***
======= Backtrace: =========
/lib/libc.so.6[0xbdc4a5]
/lib/libc.so.6(cfree+0x59)[0xbdc8e9]
/usr/lib/libstdc++.so.6(_ZdlPv+0x21)[0x42f5c1]
/home/xxx/node_modules/oracle/build/Release/oracle_bindings.node(_ZN9__gnu_cxx13new_allocatorIN6oracle4occi8MetaDataEE10deallocateEPS3_j+0x1d)[0x13c87f]
/home/xxx/node_modules/oracle/build/Release/oracle_bindings.node(_ZNSt12_Vector_baseIN6oracle4occi8MetaDataESaIS2_EE13_M_deallocateEPS2_j+0x33)[0x13c8b9]
/home/xxx/node_modules/oracle/build/Release/oracle_bindings.node(_ZNSt12_Vector_baseIN6oracle4occi8MetaDataESaIS2_EED2Ev+0x48)[0x13c908]
/home/xxx/node_modules/oracle/build/Release/oracle_bindings.node(_ZNSt6vectorIN6oracle4occi8MetaDataESaIS2_EED1Ev+0x67)[0x13e2dd]
/home/xxx/node_modules/oracle/build/Release/oracle_bindings.node(_ZN10Connection26CreateColumnsFromResultSetEPN6oracle4occi9ResultSetERSt6vectorIP8column_tSaIS6_EE+0x409)[0x138ff3]
/home/xxx/node_modules/oracle/build/Release/oracle_bindings.node(_ZN10Connection11EIO_ExecuteEP9uv_work_s+0x245)[0x13926d]
node[0x821736f]
/lib/libpthread.so.0[0x115852]
/lib/libc.so.6(clone+0x5e)[0xc46a8e]

I would try to tinker and see what I could do to help however my C skills are quite rusty.
Thank you kindly for all the work you have done so far.

Node Version: 0.8.14
OS: RHEL 5.8

LDAP auth support for Oracle connection

Sorry for posting it as an issue.

Is there a way to connect to oracle DB using LDAP for auth?

Mac OS X image not found

Spent hours trying to finally get this to build and when I did and tried to run it I get the error "Reason: image not found" because the module seems to be looking in a very obscure location for my libraries:

module.js:356
  Module._extensions[extension](this, filename);
                           ^
Error: dlopen(/Users/Alex/Documents/Source/Web/oracletest/node_modules/oracle/build/Release/oracle_bindings.node, 1): Library not loaded: /ade/b/2649109290/oracle/rdbms/lib/libocci.dylib.11.1
  Referenced from: /Users/Alex/Documents/Source/Web/oracletest/node_modules/oracle/build/Release/oracle_bindings.node
  Reason: image not found
    at Module.load (module.js:356:32)
    at Function.Module._load (module.js:312:12)
    at Module.require (module.js:364:17)
    at require (module.js:380:17)
    at Object.<anonymous> (/Users/Alex/Documents/Source/Web/oracletest/node_modules/oracle/lib/oracle.js:2:16)
    at Module._compile (module.js:456:26)
    at Object.Module._extensions..js (module.js:474:10)
    at Module.load (module.js:356:32)
    at Function.Module._load (module.js:312:12)
    at Module.require (module.js:364:17)

I am running OS 10.8.3 and using node v0.10.8

error building with node 0.8.11

when calling

 npm install oracle

I get

path.existsSync is now called `fs.existsSync`.
[1/5] cxx: src/connection.cpp -> build/Release/src/connection.o
/Users/vvolle/node_modules/oracle/src/connection.cpp: In static member function ‘static v8::Handle<v8::Value> Connection::Execute(const v8::Arguments&)’:
/Users/vvolle/node_modules/oracle/src/connection.cpp:66: error: cannot convert ‘uv_loop_t*’ to ‘uv_handle_t*’ for argument ‘1’ to ‘void uv_ref(uv_handle_t*)’
/Users/vvolle/node_modules/oracle/src/connection.cpp: In static member function ‘static v8::Handle<v8::Value> Connection::Commit(const v8::Arguments&)’:
/Users/vvolle/node_modules/oracle/src/connection.cpp:99: error: cannot convert ‘uv_loop_t*’ to ‘uv_handle_t*’ for argument ‘1’ to ‘void uv_ref(uv_handle_t*)’
/Users/vvolle/node_modules/oracle/src/connection.cpp: In static member function ‘static v8::Handle<v8::Value> Connection::Rollback(const v8::Arguments&)’:
/Users/vvolle/node_modules/oracle/src/connection.cpp:125: error: cannot convert ‘uv_loop_t*’ to ‘uv_handle_t*’ for argument ‘1’ to ‘void uv_ref(uv_handle_t*)’
/Users/vvolle/node_modules/oracle/src/connection.cpp: In static member function ‘static void Connection::EIO_AfterCommit(uv_work_t*)’:
/Users/vvolle/node_modules/oracle/src/connection.cpp:265: error: cannot convert ‘uv_loop_t*’ to ‘uv_handle_t*’ for argument ‘1’ to ‘void uv_unref(uv_handle_t*)’
/Users/vvolle/node_modules/oracle/src/connection.cpp: In static member function ‘static void Connection::EIO_AfterRollback(uv_work_t*)’:
/Users/vvolle/node_modules/oracle/src/connection.cpp:283: error: cannot convert ‘uv_loop_t*’ to ‘uv_handle_t*’ for argument ‘1’ to ‘void uv_unref(uv_handle_t*)’
/Users/vvolle/node_modules/oracle/src/connection.cpp: In static member function ‘static void Connection::EIO_AfterExecute(uv_work_t*)’:
/Users/vvolle/node_modules/oracle/src/connection.cpp:445: error: cannot convert ‘uv_loop_t*’ to ‘uv_handle_t*’ for argument ‘1’ to ‘void uv_unref(uv_handle_t*)’
[2/5] cxx: src/executeBaton.cpp -> build/Release/src/executeBaton.o
[3/5] cxx: src/oracle_bindings.cpp -> build/Release/src/oracle_bindings.o
/Users/vvolle/node_modules/oracle/src/oracle_bindings.cpp: In static member function ‘static v8::Handle<v8::Value> OracleClient::Connect(const v8::Arguments&)’:
/Users/vvolle/node_modules/oracle/src/oracle_bindings.cpp:74: error: cannot convert ‘uv_loop_t*’ to ‘uv_handle_t*’ for argument ‘1’ to ‘void uv_ref(uv_handle_t*)’
/Users/vvolle/node_modules/oracle/src/oracle_bindings.cpp: In static member function ‘static void OracleClient::EIO_AfterConnect(uv_work_t*)’:
/Users/vvolle/node_modules/oracle/src/oracle_bindings.cpp:96: error: cannot convert ‘uv_loop_t*’ to ‘uv_handle_t*’ for argument ‘1’ to ‘void uv_unref(uv_handle_t*)’
[4/5] cxx: src/outParam.cpp -> build/Release/src/outParam.o
ERROR: [Error: At least one file failed to compile.]
npm ERR! [email protected] install: `node mnm.js build`
npm ERR! `sh "-c" "node mnm.js build"` failed with 1
npm ERR! 
npm ERR! Failed at the [email protected] install script.
npm ERR! This is most likely a problem with the oracle package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR!     node mnm.js build
npm ERR! You can get their info via:
npm ERR!     npm owner ls oracle
npm ERR! There is likely additional logging output above.

npm ERR! System Darwin 11.4.2
npm ERR! command "/usr/local/bin/node" "/usr/local/bin/npm" "install" "oracle"
npm ERR! cwd /Users/vvolle
npm ERR! node -v v0.8.11
npm ERR! npm -v 1.1.62
npm ERR! code ELIFECYCLE
npm ERR! 
npm ERR! Additional logging details can be found in:
npm ERR!     /Users/vvolle/npm-debug.log
npm ERR! not ok code 0

this seems to be fixed in the newest version on GitHub but now I get:

[5/5] cxx_link: build/Release/src/connection.o build/Release/src/executeBaton.o build/Release/src/oracle_bindings.o build/Release/src/outParam.o -> build/Release/oracle_bindings.node
ld: library not found for -locci

I am building on OS X. Could it be because the 'occi' lib is only available as dynamic library?