You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
$ 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
The text was updated successfully, but these errors were encountered:
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
The text was updated successfully, but these errors were encountered: