For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi,
If I can read the Excel file with "external function", is it possible to read Excel file by calling this function with ORA_FFI package?
Please post a runnable example program plus table creation sql.
Please post input/output of the program showing the "error
Please also supply db version (4 digits), client and server OS version and architecture.
Any other information that may beuseful to re-create what you are seeing and doing.
Can you post at https://github.com/oracle/node-oracledb/issues and include the info that @"Gaz in Oz" requested?
Done, thank you. https://github.com/oracle/node-oracledb/issues/833
A general note to people reading this thread: Node.js's number range is limited so you may need to fetch numbers as strings and use a 3rd party module such as bigint to handle them 'properly'. Some details are in https://github.com/oracle/node-oracledb/issues/842 . Perhaps a better general recommendation is to do all number calculations in SQL or PL/SQL.
node-oracledb 2.1 is out with the specific regression fixed. My earlier comments about Node.js's number range still apply, of course.