Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
nuskyazhar opened this issue Jun 26, 2015 · 0 comments
Open

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

nuskyazhar opened this issue Jun 26, 2015 · 0 comments

Comments

@nuskyazhar
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant