The PL/SQL Debugger works pretty much out of the box when used with a previous Oracle version. These are the things we needed in place before we could start debugging PL/SQL:
- A grant of the DEBUG CONNECT SESSION privilege.
- EXECUTE privilege on DBMS_DEBUG_JDWP.
- EXECUTE privilege on the stored procedure you want to debug.
- Make sure the stored procedure is “Compiled for Debug”.
Jeff Smith talks about it in this post.
But what happens when you (more...)
I’ll be presenting on February 6th. Here are the details of my session:
SQL Pattern Matching in Oracle 12c
Room 501, 11:15 – 12:15
Last year I had a great time, so I can’t wait to be back in Denver.
I hope to see you there!
Filed under: RMOUG
Recursive subquery factoring (AKA Recursive Common Table Expressions) has been available in Oracle since version 11g R2 was launched sometime around 2009. I always thought of it as a replacement for the connect by clause and just another way to write hierarchical queries, so I never really took the time (more...)
This post is more like a reminder to myself on how to do this (I have a bad memory…)
By default EM Express is configured for a non-CDB or for a CDB depending on what you selected during a 12C installation and the default URL is https://hostname:5500/em
You can confirm (more...)
Yesterday I installed SQL Developer 4 on a Virtualbox VM that also contains Oracle 11g R2 and SQL Developer 3.2.20. I had no issues installing it; but as soon as I started clicking on anything that required a database connection (which is pretty much everything), the following error (more...)
After my Kscope13 presentation, one of the attendees approached me and asked if I had used regular expressions to try to validate email addresses. He didn’t know about regular expressions before the presentation and he was writing a PL/SQL function (which was getting very complex…) to accomplish this particular task. (more...)
It has been a week since I returned from Kscope13 in New Orleans and just now I’ve found some time to write about it.
This was my first visit to this city and I really enjoyed running errands to see historic locations and looking for places to try the amazing (more...)
So you haven’t decided if you should go to Kscope13. I’ll give you 5 reasons why you should stop procrastinating and register right away!
- 4½ days of great technical content for Oracle developers. Plenty of presentations and hands-on training on several areas such as APEX, BI, development tools, SQL, PL/SQL, (more...)
I was playing the pl/sql challenge the other day and the question was to identify valid implementations for a “reverse_string” function taking a varchar2 as the input and returning another varchar2 with the characters in inverted order.
One of the possible answers was this:
FUNCTION reverse_string (in_string VARCHAR2)
Well… I made it to Denver and this place is really coooold but it’s also really nice. I have this wonderful view from my hotel room.
This is just a quick post to say that I’ll be presenting on Wednesday 2/13. Here are the details of my session:
Introduction to Oracle Expressions in Oracle from 09:45 to 10:45 in room 4d
This will be the first time that I present at a conference, so as you can guess I’m a little bit anxious and nervous but I believe is normal.
I hope to see you at this great conference.