Skip to Main Content

Programming Languages & Frameworks

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!

Node-oracledb 5.0 adds Nested Cursors, Database Startup, and Prefetch Tuning

The node-oracledb 5.0 release introduces a new initialization function to let your Windows and macOS apps directly set which Oracle Client libraries to use without requiring external configuration.  This helps you automate installation on Windows and macOS, and makes it easier to distribute applications to users.

Also introduced is tunable prefetching for query fetches, giving increased scalability to applications by further allowing the round-trips between node-oracledb and the database to be optimized.

Support for nested cursors has finally arrived.

New database startup and shutdown functions allow simple and flexible control over the database.

There are other changes and some bug fixes too.

The release announcement is at:

https://blogs.oracle.com/opal/node-oracledb-50-adds-nested-cursors-database-startup-and-prefetch-tuning

The full changelog is at:

https://github.com/oracle/node-oracledb/blob/master/CHANGELOG.md

Comments

Sylvain Martel

Hello Rajesh,

The supported method is to export the concurrent executable and concurrent program you created in your DEV environment using FNDLOAD.  That will create ldt files that you would use to import in the next instance.

Example of these script are as follow:

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM"

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Hope this helps!

RajeshAlex

Thank You Sylvain

1 - 2

Post Details

Added on Jun 29 2020
0 comments
193 views