-
Notifications
You must be signed in to change notification settings - Fork 98
Description
I have,
Oracle 11g 64 bit
Node.js v0.10.33
OCI_INC_DIR --> C:\instantclient_12_1\sdk\include
OCI_INCLUDE_DIR --> C:\instantclient_12_1\sdk\include
OCI_LIB_DIR --> C:\instantclient_12_1\sdk\lib\msvc
OCI_VERSION --> 12
Path -->
C:\instantclient_12_1\vc10;C:\instantclient_12_1;C:\app\Nuskya\product\11.2.0\client_1;C:\Oracle\pr oduct\11.2.0\dbhome_1\bin;C:\ProgramData\Oracle\Java\javapath;C:\Python27;C:\Program Files\Intel\iCLS Client;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMRO OT%\System32\WindowsPowerShell\v1.0;%JAVA_HOME%\bin;c:\Program Files\Microsoft SQL Server\100\Tools\Binn;c:\Program Files\Microsoft SQL Server\100\DTS\Binn;%MAVEN_HOME%\bin;%ANT_HOME%\bin;C:\Program Files (x86)\Git\cmd;C:\Program Files\TortoiseSVN\bin;C:\Program Files (x86)\VisualSVN Server\bin;C:\Program Files\nodejs;C:\Program Files (x86)\Intel\OpenCL SDK\3.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\3.0\bin\x64;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT; C:\Oracle\product\11.2.0\dbhome_1
In 'C:\instantclient_12_1\sdk\lib\msvc' I have following files and directories,
file -> oci.lib
file -> ociw32.lib
file -> oramysql12.lib
file -> oraocci12.lib
file -> oraocci12d.lib
directory -> vc10
directory -> vc11
directory -> vc12
I have a collection 'vehicle' and SELECT vehicle_id, vehicle_name FROM vehicle returns 2 rows.
but when i run fillowing
var oracledb = require('oracledb');
oracledb.getConnection(
{
user : "testUser",
password : "password1",
connectString : "localhost/LOCALTESTDB"
},
function(err, connection)
{
if (err) {
console.error(err.message);
return;
}
connection.execute(
"SELECT vehicle_id, vehicle_name "
+ "FROM vehicle "
+ "WHERE vehicle_id = :did",
[2],
function(err, result)
{
if (err) {
console.error(err.message);
return;
}
console.log(result.rows);
});
});
I get the error ,
$ npm install oracle --save
Error: Cannot find module 'oracle'
at Function.Module._resolveFilename (module.js:338:15)
at Function.Module._load (module.js:280:25)
at Module.require (module.js:364:17)
at require (module.js:380:17)
at Client._driver (d:\LearningTests\NodeTestCodes\node_modules\knex\lib\dialects\oracle\index.js:40:12)
at Client.initializeDriver (d:\LearningTests\NodeTestCodes\node_modules\knex\lib\client.js:146:26)
at Client (d:\LearningTests\NodeTestCodes\node_modules\knex\lib\client.js:40:10)
at Client_Oracle (d:\LearningTests\NodeTestCodes\node_modules\knex\lib\dialects\oracle\index.js:29:10)
at new Client (d:\LearningTests\NodeTestCodes\node_modules\knex\lib\util\make-client.js:15:18)
at Knex (d:\LearningTests\NodeTestCodes\node_modules\knex\lib\index.js:26:19)
at Object. (d:\LearningTests\NodeTestCodes\tryouts\OracleTryouts2.js:1:89)
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 Function.Module.runMain (module.js:497:10)
Please help me resolve this.
Thanks,
Nusky