Oracle VM Site Review - Oracle VM Health Check
view counter

PL/SQL Feed

Oracle PL/SQL (Procedural Language/Structured Query Language) resources, news, and support articles.

KScope12... Ready... Set.. Go... \o/

ODTUG Kscope12 is just around the corner, yay!

  • Plane ticket - check.
  • ESTA - check.
  • Passport - check.
  • Hotel - check.
  • Schedule - check.
  • Ambassador signup - check.
  • Community Service Day signup - check.
  • Presentation prepared - check.
  • Paper written - check.
  • Demoscripts prepared - check.

Oh my... I think I am ready :-)

Overloading Procedures

A student asked, “Can you successfully overload MySQL stored procedures, like PL/SQL does in stored packages?” I said: “MySQL doesn’t formally support overloading stored procedures, and doesn’t support packages like Oracle 11g. You can, however, mimic (or fake) overloading with prepared statements. It requires a careful combination of stored procedures, session variables, and the use of a temporary table.”

Gee Thanks, Amazon

Sure, Amazon Web Services are generally amazing and wonderful.

Except when they are not.

As you can read here, "parts of Amazon Web Services (AWS) suffered an outage on Thursday which
led to a spread of high-profile sites clocking off the Web for the
evening." Like the PL/SQL Challenge.

And 10 hours later, the PL/SAL Challenge site is still not available.

NDS parameters as IN OUT?

A question posed by a student: “Why are Oracle Native Dynamic SQL (NDS) USING clause parameters IN, IN OUT, or OUT when the RETURNING INTO clause manages output values?” It a great question, isn’t it? The followup question was also great, “How do you implement an example of NDS IN OUT parameters?”

Oracle Community: Partner News & Book Beat [Oracle Magazine July/August 2012 issue]

After ACE newsletter, the book makes into Oracle Magazine Book Beat section…great feeling and satisfaction that it reaches its readers… Community: Partner News & Book Beat. Filed under: Oracle

It's Official - I am a Demigod

In its 11 June 2012 Database Application Developer Newsletter, Oracle writes  "The "PL/SQL 101" series, by PL/SQL demigod Steven Feuerstein, is the ultimate quick-start introduction to the language. Even if you are an experienced PL/SQL developer, you may find these articles a handy refresher on language fundamentals."

view counter