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

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

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 available to complete the puzzle of structured and modern programming with a touch of OO and more importantly to create a decoupled, reusable API that exposes services based on tables and views to clients that speak SQL, AQ, PL/SQL, Types, XML or RESTful, through SQL*Net, JDBC or HTTP.

This session shows through many demonstrations how types and collections are defined, how they are used between SQL and PL/SQL and how they can be converted to and from XML and JSON and how they drive Native WebServices as well as RESTful services based on the Embedded PL/SQL Gateway. Everyone doing PL/SQL programming will benefit immediately from this session. Every Database Developer should be aware of Types and Collections. For structured programming, for optimal SQL to PL/SQL integration and for interoperability to client application. This session introduces Types and Collections, their OO capabilities, the conversion to XML and JSON, their use in Native and RESTful WebServices and the pivotal role they can play in encapsulation and decoupling.

The slides can be reviewed here:

Resources

Download Slides plus Demoscripts here: AbsolutelyTypical_UKOUG2011_jellema.zip.

Related Posts

Tags:, , , , , , , ,

About The Author

Lucas Jellema

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director and Oracle Developer Champion. Solution architect and developer on diverse areas including SQL, JavaScript, Kubernetes & Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press book Oracle SOA Suite 12c Handbook. Frequent presenter on user groups and community events and conferences such as JavaOne, Oracle Code, CodeOne, NLJUG JFall and Oracle OpenWorld.

4 Comments

  1. Ezaz January 2, 2012

    It is very very interesting.  I learned a lot. Thanks

  2. Chris Neumueller December 13, 2011

    Interesting presentation, thanks a lot for sharing. In my experience, types are also very useful for wrapping existing PL/SQL functionality. Surprisingly powerful abstractions are possible this way, for example closures (on top of dbms_sql): http://unclechrisblog.blogspot.com/2011/07/closures-in-plsql.html

  3. Lucas Jellema December 13, 2011

    Hi Richard,

    By all means, make whatever use of it you can. Glad to hear you liked it. And good luck with your presentation.

    Lucas

  4. Richard Martens December 12, 2011

    Thanks Lucas, very interesting subject. Do you mind if I use your presentation as one of the sources for a presentation I am preparing for my collegues?