Tag: type

Absolutely Typical – The whole story on Types and how they power PL/SQL Interoperability (UKOUG, 2011)

Lucas Jellema December 12, 2011 Database, PL/SQL, XML 4 Comments

This presentation will hopefully convince database developers that types in the Oracle Database are worth their salt – and more. With the recent improvements in 11gR2, the pieces are …

[Continue Reading...]

Oracle & JDBC – Passing a ‘table of custom object type’ to a stored procedure – implementing efficient single round trip data exchange (part two of an ADF application on a PL/SQL API)

Lucas Jellema July 16, 2008 Database, Databases, IT, Java, Oracle, Oracle ADF, Oracle WebLogic Server 3 Comments

One very efficient way of passing data from the Java application to the database is through the use of custom Oracle Types. Even when we want to send a …

[Continue Reading...]

Juggling with SQL Types in SQL and PL/SQL – fading borders between Collection and Table

Lucas Jellema July 14, 2008 Database, Databases, Java, Oracle, PL/SQL 1 Comment

While preparing for a whole different topic, I had to create a few demonstrations of using custom SQL Types and Collections in both SQL and PL/SQL. While nothing spectacular …

[Continue Reading...]