PLSQL Warning Messages in Oracle SQL Developer

thatjeffsmith SQL Developer 2 Comments

If you have problems in your PL/SQL program that prevent compilation and execution of said program, then that is reported back as an ‘error.’ It could be as simple as missing a semicolon – CREATE OR REPLACE FUNCTION "COUNTRIES_ROWS_BACK" RETURN sys_refcursor IS l_curvar sys_refcursor; BEGIN OPEN l_curvar FOR ‘SELECT * FROM countries’   RETURN l_curvar; END COUNTRIES_ROWS_bACK; When you run …

SQLDev Trick: SHIFT+Hover to Peek Into a Stored Proc

thatjeffsmith SQL Developer 5 Comments

I’m poking around an unfamiliar schema or environment. I’m not sure what these procedures do. I could open them, but I’m lazy and I don’t want the tool to open another document/window. The ‘mystery’ code: These programs are self-documenting as they have the most awesome names ever! I’m guessing that one package will blast my enemies?, but I’m not sure. …

Viewing PLSQL Compilation Errors in Oracle SQL Developer

thatjeffsmith SQL Developer 6 Comments

A question that comes up fairly frequently revolves around how to see your errors when working with PL/SQL in SQL Developer. Most folks are probably working in the worksheet – this is the default editor for your connection. Let’s take a look at this sample program CREATE OR REPLACE PROCEDURE do_nothing IS BEGIN dbms_output.put(sysdate); this should probably error OUT, RIGHT? …

‘New’ Technology from 2000

thatjeffsmith Database Stuff 5 Comments

I spend a lot of time speaking to PL/SQL development teams. A conservative estimate would break down to about 200 presentations a year and 2,000 developers. I have several stock presentations, but I prefer to have conversations with my audience rather than just start throwing slides up on the projector. If we find a topic of interest, then I can …