http://twitter.com/stevefeuerstein
Oracle PL/SQL expert, evangelist, author and trainer
Areas of Expertise:
- PL/SQL
- Oracle
- stored procedures
- consulting
- speaking
- training
- writing
Steven blogs at:
http://feuerthoughts.blogspot.com
http://www.toadworld.com/sf
"Our" Error Codes : -20999 to -20000
February 03 2012
Oracle PL/SQL provides the RAISE_APPLICATION_ERROR built-in procedure (actually defined in the DBMS_STANDARD package) so that we can communicate application-specific error messages back to our users. When you call this procedure, you provide a negative number between -20999 and -20000, as well as your error message. Here's an example of calling RAISE_APPLICATION_ERROR… read moreEver wanted to debug lobs, object types, XML docs in your IDE?
January 10 2012
"Exotic" datatypes, like large objects, object types, XML documents, etc. are being used by more and more Oracle development teams. And those teams, of course, are using one of many different IDEs for PL/SQL, including Toad, SQL Navigator, PL/SQL Developer, SQL Developer, etc. These IDEs come with source code debuggers, but… read moreDebugging "Exotic" PL/SQL Data Types
January 10 2012
The "new" debugging architecture (Java Debug Wire Protocol-based) that was introduced in Oracle Database 9i Release 2 was a major improvement on the previous one (DBMS_DEBUG), especially because it made it possible to inspect the values of a wider range of data types. However, it's still not possible to inspect… read moreUsing CONTINUE in a PL/SQL Block
December 19 2011
Oracle added the CONTINUE statement in Oracle Database 11g to simplify the logic you would have to write when you need to terminate execution of code within the body of a loop. CONTINUE is especially helpful when you are executing nested loops and need to skip the remainder of the… read moreEvery VARCHAR2(N) Declaration a Bug!
December 13 2011
This is something I say in my best practice trainings: Consider every VARCHAR2(N) declaration to be a bug – unless it's a SPOD. What, you might ask, is a SPOD? It's the single point of definition - the one place in your code where the thing you are working with (datatype,… read moreGingrich the Man - When the bar is set very low
December 02 2011
Here's what Newt Gingrich says about himself:"I don't claim to be the perfect candidate. I just claim to be a lot more conservative than Mitt Romney and a lot more electable than anyone else."Wow, now that's truly inspiring, Newt. Not. Mostly it just tells you how terrible the field of… read moreThe Power of Determinism in Oracle Database 11g
November 28 2011
A function is considered to be deterministic if it returns the same result value whenever it is called with the same values for its IN and IN OUT arguments. Another way to think about deterministic programs is that they have no side-effects. Everything the program depends on and/or affects is… read moreOh, Frabjous Joy, I Am a Grandfather!
November 07 2011
Our very first ever in the whole wide world grandchild - our granddaughter, Loey Lucille - was born at 9:54 this morning, 30 October 2011. Ah, what a glorious feeling! Everyone is doing well, excellently, and Loey Lucille is clearly thriving from the get-go. Her father, my son, Chris, has… read moreWanted: Your Ideas for Enhancements to PL/SQL
October 28 2011
On November 9, I will be doing the keynote presentation at the 100th member meeting of the Northern California OUG. The day before that I will visit with the PL/SQL development team at Oracle HQ.It's always great to catch up not just with Bryn Llewellyn, the PL/SQL Product Manager, but also… read more
Also find Steven on:
Recent Twitter posts:
Buy Now and Save
Buy 2 books, get the 3rd FREE
Use discount code: OPC10
All orders over $29.95 qualify for free shipping within the US. See details.
Use discount code: OPC10
All orders over $29.95 qualify for free shipping within the US. See details.
