Friday, September 15, 2017

PL/SQL Record Types and the Node.js Driver

DZone Database Zone
PL/SQL Record Types and the Node.js Driver
PL/SQL Record Types and the Node.js Driver

The current version of the Node.js driver (v1.12) doesn't support binding record types directly. Does that mean you can't invoke stored procedures and functions that use record types? Of course not! For now, you just have to decompose the record types for binding and then recompose them inside your PL/SQL block. Let's have a look at an example...

Imagine we have the following PL/SQL package spec and body:

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...