{"_id":"oracle","_rev":"13-a9217539f9cc6e265cf4bf276f5fdba9","name":"oracle","description":"Oracle database driver","dist-tags":{"latest":"0.3.0"},"versions":{"0.1.0":{"name":"oracle","description":"Oracle database driver","keywords":["database","db","oracle"],"homepage":"https://github.com/joeferner/node-oracle","version":"0.1.0","engines":{"node":">=0.6.0"},"maintainers":[{"name":"joeferner","email":"joe@fernsroth.com"}],"bugs":{"url":"https://github.com/joeferner/node-oracle/issues"},"repositories":[{"type":"git","url":"https://github.com/joeferner/node-oracle"}],"scripts":{"install":"node-waf configure build"},"devDependencies":{"nodeunit":"~>0.6.4"},"_npmUser":{"name":"joeferner","email":"joe@fernsroth.com"},"_id":"oracle@0.1.0","dependencies":{},"_engineSupported":true,"_npmVersion":"1.1.0-alpha-6","_nodeVersion":"v0.6.4","_defaultsLoaded":true,"dist":{"shasum":"c2fb02d8c1b955066b80f3a179fb6cc217e1605c","tarball":"http://registry.npmjs.org/oracle/-/oracle-0.1.0.tgz"},"directories":{}},"0.1.1":{"name":"oracle","description":"Oracle database driver","keywords":["database","db","oracle"],"homepage":"https://github.com/joeferner/node-oracle","version":"0.1.1","engines":{"node":">=0.6.0"},"maintainers":[{"name":"joeferner","email":"joe@fernsroth.com"}],"bugs":{"url":"https://github.com/joeferner/node-oracle/issues"},"repositories":[{"type":"git","url":"https://github.com/joeferner/node-oracle"}],"scripts":{"install":"node-waf configure build"},"devDependencies":{"nodeunit":"~>0.6.4"},"_npmUser":{"name":"joeferner","email":"joe@fernsroth.com"},"_id":"oracle@0.1.1","dependencies":{},"_engineSupported":true,"_npmVersion":"1.1.0-alpha-6","_nodeVersion":"v0.6.4","_defaultsLoaded":true,"dist":{"shasum":"872b7244e00f844dff3b246c8662867cb805ca56","tarball":"http://registry.npmjs.org/oracle/-/oracle-0.1.1.tgz"},"directories":{}},"0.1.2":{"name":"oracle","description":"Oracle database driver","keywords":["database","db","oracle"],"homepage":"https://github.com/nearinfinity/node-oracle","version":"0.1.2","engines":{"node":">=0.6.0"},"maintainers":[{"name":"joeferner","email":"joe@fernsroth.com"}],"bugs":{"url":"https://github.com/nearinfinity/node-oracle/issues"},"repositories":[{"type":"git","url":"https://github.com/nearinfinity/node-oracle"}],"scripts":{"install":"node-waf configure build"},"devDependencies":{"nodeunit":"~>0.6.4"},"_npmUser":{"name":"joeferner","email":"joe@fernsroth.com"},"_id":"oracle@0.1.2","dependencies":{},"_engineSupported":true,"_npmVersion":"1.1.0-alpha-6","_nodeVersion":"v0.6.4","_defaultsLoaded":true,"dist":{"shasum":"4c86d02c1175526c675f708cb8c17b04e2572888","tarball":"http://registry.npmjs.org/oracle/-/oracle-0.1.2.tgz"},"directories":{}},"0.1.3":{"name":"oracle","description":"Oracle database driver","keywords":["database","db","oracle"],"homepage":"https://github.com/nearinfinity/node-oracle","version":"0.1.3","engines":{"node":">=0.6.0"},"maintainers":[{"name":"joeferner","email":"joe@fernsroth.com"}],"bugs":{"url":"https://github.com/nearinfinity/node-oracle/issues"},"repository":{"type":"git","url":"git://github.com/nearinfinity/node-oracle.git"},"dependencies":{"mnm":"~0.0.2"},"devDependencies":{"nodeunit":"~>0.6.4"},"scripts":{"test":"nodeunit test","install":"node mnm.js build"},"main":"./index.js","_npmUser":{"name":"joeferner","email":"joe@fernsroth.com"},"_id":"oracle@0.1.3","optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.4","_nodeVersion":"v0.7.11","_defaultsLoaded":true,"dist":{"shasum":"083048b630bce10bae8ad742a537f9c431e5ac76","tarball":"http://registry.npmjs.org/oracle/-/oracle-0.1.3.tgz"},"directories":{}},"0.2.0":{"name":"oracle","description":"Oracle database driver","keywords":["database","db","oracle"],"homepage":"https://github.com/nearinfinity/node-oracle","version":"0.2.0","engines":{"node":">=0.6.0"},"maintainers":[{"name":"joeferner","email":"joe@fernsroth.com"}],"bugs":{"url":"https://github.com/nearinfinity/node-oracle/issues"},"repository":{"type":"git","url":"git://github.com/nearinfinity/node-oracle.git"},"dependencies":{"mnm":"~0.0.2"},"devDependencies":{"nodeunit":"~>0.6.4"},"scripts":{"test":"nodeunit test","install":"node mnm.js build"},"main":"./index.js","readme":"# Install\n\n * Install [Instant Client Package - Basic Lite](http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)\n * Install [Instant Client Package - SDK](http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)\n * Finally install using Node Package Manager (npm):\n\n    npm install oracle\n\n# Example\n\n```javascript\nvar oracle = require(\"oracle\");\n\noracle.connect({ \"hostname\": \"localhost\", \"user\": \"test\", \"password\": \"test\" }, function(err, connection) {\n  // selecting rows\n  connection.execute(\"SELECT * FROM person WHERE name = :1\", ['bob smith'], function(err, results) {\n    // results will be an array of objects\n  });\n\n  // inserting with return value\n  connection.execute(\n    \"INSERT INTO person (name) VALUES (:1) RETURNING id INTO :2\",\n    ['joe ferner', new oracle.OutParam()],\n    function(err, results) {\n      // results.updateCount = 1\n      // results.returnParam = the id of the person just inserted\n    });\n\n  connection.setAutoCommit(true);\n\n  connection.commit(function(err) {\n    // transaction committed\n  });\n\n  connection.rollback(function(err) {\n    // transaction rolledback\n  });\n\n  connection.close(); // call this when you are done with the connection\n});\n```\n\n# Develop\n\n## Install Oracle/Oracle Express\n\n * Download [Oracle Express 10g](http://www.oracle.com/technetwork/database/express-edition/database10gxe-459378.html)\n * Download [Instant Client](http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)\n  * Instant Client Package - Basic Lite\n  * Instant Client Package - SQL*Plus\n  * Instant Client Package - SDK\n * Install Oracle Express (Ubuntu)\n\n```bash\nsudo dpkg -i oracle-xe_11.2.0.3.0-1.0_i386.deb\nsudo apt-get install alien\nsudo alien oracle-instantclient11.2-*\nsudo dpkg -i oracle-instantclient11.2-*.deb\nsudo /etc/init.d/oracle-xe configure\n```\n\n * Open http://localhost:9999/apex/ change 9999 to the port you configured. Log-in with \"sys\" and the password.\n * Create a user called \"test\" with password \"test\" and give all accesses.\n\n```bash\nsudo vi /etc/ld.so.conf.d/oracle.conf -- add this line /usr/lib/oracle/11.2/client/lib/\nsudo ldconfig\n\nexport ORACLE_SID=test\nexport ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/11.2/server\nexport OCI_INCLUDE_DIR=/usr/include/oracle/11.2/client/\nexport OCI_LIB_DIR=/usr/lib/oracle/11.2/client/lib/\nsqlplus test@XE\n```\n\n## Build\n\n```bash\nnode-waf configure\nnode-waf build\nnodeunit tests/*\n```\n","readmeFilename":"README.md","_id":"oracle@0.2.0","dist":{"shasum":"054996bfb00eb36ef703169c33de943eaa65ad40","tarball":"http://registry.npmjs.org/oracle/-/oracle-0.2.0.tgz"},"_npmVersion":"1.1.65","_npmUser":{"name":"joeferner","email":"joe@fernsroth.com"},"directories":{}},"0.3.0":{"name":"oracle","description":"Oracle database driver","keywords":["database","db","oracle"],"homepage":"https://github.com/nearinfinity/node-oracle","version":"0.3.0","engines":{"node":">=0.6.0"},"maintainers":[{"name":"joeferner","email":"joe@fernsroth.com"}],"bugs":{"url":"https://github.com/nearinfinity/node-oracle/issues"},"repository":{"type":"git","url":"git://github.com/nearinfinity/node-oracle.git"},"dependencies":{},"devDependencies":{"nodeunit":"~>0.8.0"},"scripts":{"test":"nodeunit test/integration.js test/outparams.js","install":"node-gyp rebuild"},"main":"./index.js","gypfile":true,"readme":"# Install\n\n * Install [Instant Client Package - Basic Lite](http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)\n * Install [Instant Client Package - SDK](http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)\n * Finally install using Node Package Manager (npm):\n\n    npm install oracle\n\n# Example\n\n```javascript\nvar oracle = require(\"oracle\");\n\noracle.connect({ \"hostname\": \"localhost\", \"user\": \"test\", \"password\": \"test\" }, function(err, connection) {\n  // selecting rows\n  connection.execute(\"SELECT * FROM person WHERE name = :1\", ['bob smith'], function(err, results) {\n    // results will be an array of objects\n  });\n\n  // inserting with return value\n  connection.execute(\n    \"INSERT INTO person (name) VALUES (:1) RETURNING id INTO :2\",\n    ['joe ferner', new oracle.OutParam()],\n    function(err, results) {\n      // results.updateCount = 1\n      // results.returnParam = the id of the person just inserted\n    });\n\n  connection.setAutoCommit(true);\n\n  connection.commit(function(err) {\n    // transaction committed\n  });\n\n  connection.rollback(function(err) {\n    // transaction rolledback\n  });\n\n  connection.close(); // call this when you are done with the connection\n});\n```\n\n## Out Params\n\nThe following Out Params are supported in Stored Procedures:\n\n```\n\nOCCIINT\nOCCISTRING\nOCCIDOUBLE\nOCCIFLOAT\nOCCICURSOR\nOCCICLOB\nOCCIDATE\nOCCITIMESTAMP\nOCCINUMBER\nOCCIBLOB\n\n```\n\nAnd can be used as follows:\n\n```\n\nconnection.execute(\"call myProc(:1,:2)\", [\"nodejs\", new oracle.OutParam(oracle.OCCISTRING)], function(err, results){\n  console.dir(results);\n};\n\n```\n\nWhen using Strings as Out Params, the size can be optionally specified as follows:\n\n```\n\nconnection.execute(\"call myProc(:1,:2)\", [\"nodejs\", new oracle.OutParam(oracle.OCCISTRING, {size: 1000})], function(err, results){\n\n```\n\nIf no size is specified, a default size of 200 chars is used.\n\nSee tests for more examples.\n\n## In/Out Params\n\nThe following INOUT param types are supported:\n\n```\n\nOCCIINT\nOCCISTRING\nOCCIDOUBLE\nOCCIFLOAT\nOCCINUMBER\n\n```\n\nINOUT params are used like normal OUT prams, with the optional 'in' paramater value being passed in the options object:\n\n```\n\nconnection.execute(\"call myProc(:1)\", [new oracle.OutParam(oracle.OCCIINT, {in: 42})], function(err, results){\n  console.dir(results);\n};\n\n```\n\n\n# Develop\n\n## Install Oracle/Oracle Express\n\n * Download [Oracle Express 10g](http://www.oracle.com/technetwork/database/express-edition/database10gxe-459378.html)\n * Download [Instant Client](http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)\n  * Instant Client Package - Basic Lite\n  * Instant Client Package - SQL*Plus\n  * Instant Client Package - SDK\n * Install Oracle Express (Ubuntu)\n\n```bash\nsudo dpkg -i oracle-xe_11.2.0.3.0-1.0_i386.deb\nsudo apt-get install alien\nsudo alien oracle-instantclient11.2-*\nsudo dpkg -i oracle-instantclient11.2-*.deb\nsudo /etc/init.d/oracle-xe configure\n```\n\n * Open http://localhost:9999/apex/ change 9999 to the port you configured. Log-in with \"sys\" and the password.\n * Create a user called \"test\" with password \"test\" and give all accesses.\n\n```bash\nsudo vi /etc/ld.so.conf.d/oracle.conf -- add this line /usr/lib/oracle/11.2/client/lib/\nsudo ldconfig\n\nexport ORACLE_SID=test\nexport ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/11.2/server\nexport OCI_INCLUDE_DIR=/usr/include/oracle/11.2/client/\nexport OCI_LIB_DIR=/usr/lib/oracle/11.2/client/lib/\nsqlplus test@XE\n```\n\n## Build\n\n```bash\nnpm install\nnpm test\n```\n","readmeFilename":"README.md","_id":"oracle@0.3.0","dist":{"shasum":"ca39f944ca6f8d0b40920fcd3545659f78c98ce2","tarball":"http://registry.npmjs.org/oracle/-/oracle-0.3.0.tgz"},"_from":".","_npmVersion":"1.2.14","_npmUser":{"name":"joeferner","email":"joe@fernsroth.com"},"directories":{}}},"readme":"# Install\n\n * Install [Instant Client Package - Basic Lite](http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)\n * Install [Instant Client Package - SDK](http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)\n * Finally install using Node Package Manager (npm):\n\n    npm install oracle\n\n# Develop\n\n## Install Oracle/Oracle Express\n\n * Download [Oracle Express 10g](http://www.oracle.com/technetwork/database/express-edition/database10gxe-459378.html)\n * Download [Instant Client](http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)\n  * Instant Client Package - Basic Lite\n  * Instant Client Package - SQL*Plus\n  * Instant Client Package - SDK\n * Install Oracle Express (Ubuntu)\n\n```bash\nsudo dpkg -i oracle-xe_11.2.0.3.0-1.0_i386.deb\nsudo apt-get install alien\nsudo alien oracle-instantclient11.2-*\nsudo dpkg -i oracle-instantclient11.2-*.deb\nsudo /etc/init.d/oracle-xe configure\n```\n\n * Open http://localhost:9999/apex/ change 9999 to the port you configured. Log-in with \"sys\" and the password.\n * Create a user called \"test\" with password \"test\" and give all accesses.\n \n```bash\nsudo vi /etc/ld.so.conf.d/oracle.conf -- add this line /usr/lib/oracle/11.2/client/lib/\nsudo ldconfig\n\nexport ORACLE_SID=test\nexport ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/11.2/server\nexport OCI_INCLUDE_DIR=/usr/include/oracle/11.2/client/\nexport OCI_LIB_DIR=/usr/lib/oracle/11.2/client/lib/\nsqlplus test@XE\n```\n\n## Build\n\n```bash\nnode-waf configure\nnode-waf build\nnodeunit tests/*\n```\n\n","maintainers":[{"name":"joeferner","email":"joe@fernsroth.com"}],"time":{"0.1.0":"2011-12-22T15:03:25.680Z","0.1.1":"2011-12-27T16:56:35.173Z","0.1.2":"2011-12-28T14:40:21.871Z","0.1.3":"2012-06-22T17:46:52.350Z","0.2.0":"2012-12-03T20:03:52.536Z","0.3.0":"2013-05-03T14:52:35.973Z"},"repository":{"type":"git","url":"git://github.com/nearinfinity/node-oracle.git"},"_attachments":{"oracle-0.3.0.tgz":{"content_type":"application/octet-stream","revpos":12,"digest":"md5-plb5g18Qop4Wso30GUebgg==","length":13287,"stub":true},"oracle-0.2.0.tgz":{"content_type":"application/octet-stream","revpos":11,"digest":"md5-gxOJpg/R/bLkKiCgscPL6g==","length":10360,"stub":true},"oracle-0.1.3.tgz":{"content_type":"application/octet-stream","revpos":9,"digest":"md5-L7qkTEtmNV7QPmZ5CAakaA==","length":9611,"stub":true},"oracle-0.1.2.tgz":{"content_type":"application/octet-stream","revpos":7,"digest":"md5-mC2DAp1OWXFXmLUReqf8gw==","length":9669,"stub":true},"oracle-0.1.1.tgz":{"content_type":"application/octet-stream","revpos":5,"digest":"md5-qDv8PfEFbdXaNOyAkCEilw==","length":9655,"stub":true},"oracle-0.1.0.tgz":{"content_type":"application/octet-stream","revpos":3,"digest":"md5-4jCBDzdNyafMzk/XQwjfiA==","length":8927,"stub":true}}}