Fetch all columns as strings

[mhgill]

This is my code:

var get_ddl = function(conn, cb) {
  conn.execute(
    ddl_cmd,
    [178],
    {
      fetchInfo :
      {
        ?ALL?:    { type : oracledb.STRING },  // return the date as a string
      }
    },
    function(err, result) {
      console.log(result.rows);

    });
};

This is the example code:

function(err, connection) {
    if (err) {
      console.error(err.message);
      return;
    }
    connection.execute(
      "SELECT last_name, hire_date, salary, commission_pct FROM employees WHERE employee_id = :id",
      [178],
      {
        fetchInfo :
        {
          "HIRE_DATE":      { type : oracledb.STRING },  // return the date as a string
          "COMMISSION_PCT": { type : oracledb.DEFAULT }  // override oracledb.fetchAsString
        }
      },
      function(err, result) {
        if (err) {
          console.error(err.message);
          doRelease(connection);
          return;
        }
        console.log(result.rows);
        doRelease(connection);
      });
  });

In the example, the columns have names: HIRE_DATE, and COMMISSION_PCT.
The column I am fetching, i assume has no name, the result is just some rows. I want to fetch all rows as strings. what should I replace ?ALL? with? Also, what is [178] and why did he put that there?

[Edite: code markdown added by @cjbj]

[anthony-tuininga]

The [178] in the code refers to bind values. See the documentation for more information.

If you want to fetch all columns of a particular type as string then you need to use the fetchAsString directive which you can find the the documentation.

[dmcghan]

@mhgill Take a quick look at how to post code in GitHub: https://help.github.com/articles/creating-and-highlighting-code-blocks/

It's a little hard to understand what you're doing here. Could you please tell us a little about the ddl_cmd you're executing?

[mhgill]

The example code is from the fetchinfo.js file from the examples directory given. I understand that I need to use the fetchasstring directive, but how and where? sorry, I am new to documentation and dont really know how to use it. Can you give an example?

Also,
ddl_cmd = "select dbms_metadata.get_ddl('TABLE', table_name) from user_tables"

[anthony-tuininga]

The fetchinfo.js from the examples directory shows you how to use oracledb.fetchAsString, too. Take a closer look, especially at lines 34 and 35.

[dmcghan]

@mhgill Ah, now the variable name ddl_cmd makes more sense.

dbms_metadata.get_ddl returns a CLOB. See these examples for querying CLOBs out as simple strings:
https://oracle.github.io/node-oracledb/doc/api.html#querying-lobs

[cjbj]

Closing - no activity.