PL/SQL enhancements in version 11

24 August 2006 at 09:39 CEST | In Database, Oracle, PL/SQL programming |

I was just browsing the session catalog for Oracle OpenWorld 2006 Develop to see whether it is worth while to visit. I stumbled upon a session by Bryn Llewellyn, PL/SQL product manager from Oracle entitled “PL/SQL Enhancements in the Next Major Release of Oracle Database”.

The session abstract itself already gives a good idea of the new features he will be talking about. It sounds very promising:

Native compilation now requires no C compiler, because the PL/SQL compiler generates the machine code DLL directly. The file system directory is no longer needed, and only the PLSQL_Code_Type parameter remains.

A brand-new systemwide function result cache speeds performance, by avoiding expensive recalculation. Declarative mechanisms are provided to purge a cached result when, for example, table data it relies on changes.

Dependencies are now tracked at the level of the element (subprogram, variable, type declaration, cursor, and so on) in a package or the column in tables. A PL/SQL unit that depends only on elements that are not changed is now not invalidated when other elements are changed. This has the added benefit that the frequency of ORA-04068 errors in a multiuser environment is reduced.

Through Oracle Database 10g, there are some gaps in PL/SQL’s method 4 dynamic SQL functionality. These are now filled. For example, a DBMS_Sql cursor that was opened for a select statement whose select list or bind requirements are not known until runtime can now be converted to a ref cursor to return to a client-side application.

The new compound trigger allows code to be defined that fires at “before statement,” “before each row,” “after each row,” and “after statement” times in a single compilation unit. The unit can declare global state that lasts just for the duration of the firing SQL statement.

These are just a few of the PL/SQL enhancements brought by the next major release of Oracle Database. In this session, you learn about them all.

15 Comments

TrackBack URI

  1. Maybe PL/SQL need a GUI…

    Comment by zeeno — 24 August 2006 #

  2. Sounds sweet, especially the part about partial dependencies.

    Now, if we could also have that 32K string length limit removed…

    :-)

    Comment by OraMan — 24 August 2006 #

  3. Converting a DBMS_SQL cursor into a REF cursor — that’s just great!

    Comment by Alex — 28 August 2006 #

  4. ORACLE IS INTERNATIONALY USED, FOR THIS REASON I REQUEST YOU TO PROVIDE INTEGRATED PL/SQL REFERENCE FOR BEGGINERS IN YOUR WEBSITE FOR FREE

    Comment by ABDALMOHSIN — 21 October 2006 #

  5. Penis enlargement, natural penis enlargement, male enhancement, erectile dysfunction, premature ejaculation, erections, male enhancement, penus enlargement and penile enlargement products review for big penis size. http://www.penis4enlargement.com

    Comment by penis enlargement — 11 January 2009 #

  6. Best Penis Enlargement & Male Enhancement Product -Best Penis Enlargement And Male Enhancement Methods To Overcome The Problem Of Men.Products details to enlarge penis by penis enlargement pills, penis patches, penis extenders, penis devies, and penis enlargement exercises.

    Comment by buy penis enlargement — 20 January 2009 #

  7. Penis Size Enlargement (All-Natural Sexual Health Products) all-natural herbal male enhancement pills increase penis size and sex drive. Does penis enlargement pills really work? Permanent penis enlargement through penis pills. Choosing the best product seems to be the most difficult of all. There are penis exercises, penis devices, penis patches and top rated penis enlargement pills at http://www.male-sexual-styles.com

    Comment by Penis Size Enlargement (All-Natural Sexual Enhancement Products) — 12 July 2009 #

  8. Penis enlargement products reviews for penis size enlargement by world’s best natural herbal penis enlargement products like ( penis enlargement pills, penis patches, penis devices, and penis exercises ) for increase penis size in girth and length in weeks with more harder and solid erections at http://www.bestpenisproducts.com

    Comment by Penis Enlargement — 22 July 2009 #

  9. hi every one .. I want to know some thing. Which is that how to increases our own website pr . My site is that http://www.penisenlargementy.com

    Comment by Natural Penis Enlargement — 19 August 2009 #

  10. Hair Loss Treatments - Products Cures and Solutions Guide. Read the Hair Loss Guide - Know about Causes, Treatments, Solutions and hairstyles for Men and Women at http://www.Managehairloss.com

    Comment by Hair loss — 20 August 2009 #

  11. Cheap Penis enlargement, Male enhancement, premature ejaculation and erectile dysfunction products and treatments at http://www.gordoniihoodia.net

    Comment by male enlargement — 3 September 2009 #

  12. Penis enlargement by Naturalherbalz will improve every aspect of your life immensely. As long as you make use of all the resources available to your through this site, your visit here will not be in vain. We offer you the best penis enlargement methods you can attain on the market today at http://www.Naturalherbalz.com

    Comment by Penis enlargement — 7 September 2009 #

  13. Want to get bigger penis size in few weeks without any side effects? Get best penis enlargement products that enlarge penis size naturally at http://www.penis4enlargement.com

    Comment by Bigger penis — 15 September 2009 #

  14. hi every one I m new in this kind of blog. I read this blog and I get lots of important information over this thanks to this blog owener

    Comment by Prosolution — 28 September 2009 #

  15. hi every one I m new in this kind of blog. I read this blog and I get lots of important information over this thanks to this blog owner. http://www.prosolutionforpenisenlargement.com

    Comment by Prosolution — 29 September 2009 #

Sorry, the comment form is closed at this time.

Powered by WordPress with Pool theme design by Borja Fernandez.
Entries and comments feeds.