Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

Note!

All database-related APL functions use a db connection pool, and they pick a connection from the pool for each invocation. Connection properties, such as the transaction state, are handled internally by each function and are never visible in APL. 

These database functions are currently designed to work with the following database data types; characterstringinteger and date data types such as VARCHAR, INTEGER, NUMBER, DATE and TIMESTAMP.  

Other database data types are restricted for APL database functions. The list below contains examples of such types, usually very large data types or custom objects, structures and similar types.

  • Large object data types such as BLOB/CLOB

  • User-defined structures/objects

  • User-defined collections/arrays

  • Spatial/Geometry

  • JSON, XML

  • Boolean

Info

The BLOB data is parsed and stored as a hex string and CLOB data as a string. To insert BLOB data using APL, you must use string/bytearray.

...