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.

Big Mistake by Steven, No Quiz on Monday (for Many)

Dear PL/SQL Challenge Players,

I made a very big mistake today, and the result is that many of you could not play Monday's quiz.

I switched to maintenance mode at 15:00 to fix a bug, but then neglected to return to normal mode of play.

Then, seeing as I am in Taos, NM, I left the world of computers behind for Bandelier National Monument, an amazing place....but as a result, I did not notice that so many of you were notifying me of a problem with the site.

My deepest apologies. We will have to void the results for Monday's quiz.

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

view counter