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.
ODTUG Kscope12 is just around the corner, yay!
Oh my... I think I am ready :-)
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.”
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.
A question posed by a student: “Why are Oracle Native Dynamic SQL (NDS) USING clause parameters
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?”
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