SYS_REFCURSOR

user13423260

HI,

Have node-oracledb support for sys_refcursor?

example:

oracledb.getConnection(
  {
       user : dbConfig.user,
       password : dbConfig.password,
       connectString : dbConfig.connectString
  },
  function(err, connection) {
   if (err) { console.log("Error connecting to db:", err); return; }
   var bindvars = {
      ???
  }
   connection.execute(
   "BEGIN " +
        "getDBUSERCursor('mkyong',:c_dbuser); " +
        "LOOP " +
             "ETCH :c_dbuser INTO :temp_dbuser; " +
             "EXIT WHEN c_dbuser%NOTFOUND; " +
             "dbms_output.put_line(:temp_dbuser.username); " +
        "END LOOP; " +
   "CLOSE c_dbuser; " +
   "END;",
   bindvars,

  function(err, results) {
        if (err) { console.log("Error executing query:", err); return; }
        console.log(results.outBinds);
   });
});  

CREATE OR REPLACE PROCEDURE getDBUSERCursor(

p_username IN DBUSER.USERNAME%TYPE,

c_dbuser OUT SYS_REFCURSOR)

IS

BEGIN

  OPEN c_dbuser FOR

  SELECT * FROM DBUSER WHERE USERNAME LIKE p_username || '%';

END;

/

Thanks!

Christopher Jones-Oracle

Not at this moment.  Once it has a normal result set API (instead of returning all rows like it currently does), then we will able to build on top of that for REF CURSORS. See https://github.com/oracle/node-oracledb/issues/5