Skip to content

Error: The specified procedure could not be found. #257

@nuskyazhar

Description

@nuskyazhar

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions