Skip to Main Content

Oracle Forms

Announcement

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!

Is it possible to read file on client with ORA_FFI package?

study-fengDec 31 2019 — edited Jan 2 2020

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?

Comments

Gaz in Oz

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.

Christopher Jones-Oracle

Can you post at https://github.com/oracle/node-oracledb/issues  and include the info that @"Gaz in Oz" requested?

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.

1 - 5

Post Details

Added on Dec 31 2019
1 comment
219 views