Category Archives: PL/SQL

HTML formatted emails with utl_smtp

Posted on 27 September 2010 by Andrew Fraser

HTML format emails allows images, fonts, colours, hyperlinks. It can be done with utl_smtp (after the jump) and with utl_mail

Posted in Email, PL/SQL, Scripts | Tagged | Leave a comment

O’Reilly’s Steve Feuerstein Oracle PL/SQL Programming

Posted on 16 June 2010 by Andrew Fraser

O’Reilly’s Steve Feuerstein Oracle PL/SQL Programming, 2nd Edition online at http://soft.buaa.edu.cn/oracle/bookshelf/Oreilly/prog2/

Posted in Book review, PL/SQL | Leave a comment

PLS-00999: implementation restriction (may be temporary) RESULT_CACHE is disallowed on subprograms with OUT or IN OUT parameters

Posted on 5 May 2010 by Andrew Fraser

Result cache functions are a good new feature in Oracle 11g, but they only work with normal functions. A function that returns multiple outputs using OUT parameters cannot be made a result cache function, at least not in 11gR1. Attempting … Continue reading →

Posted in Performance tuning, PL/SQL | Leave a comment

Introduction to PL/SQL By Example

Posted on 19 March 2009 by Andrew Fraser

Here are online course notes, with code examples, for a simple introduction to Oracle’s PL/SQL language. Was originally aimed especially at Infrastructure DBAs, but would be of use to anyone learning PL/SQL.

Posted in PL/SQL | Leave a comment