Let’s talk about ‘Squiggles’ – What’s Wrong with Your SQL or PLSQL?

thatjeffsmith SQL Developer 1 Comment

SQL Developer’s code editors try to help you out. They’ll show you two categories of informational advisories: there is a problem with this code we think we can help you with this code These are shown by various styles of underlined text in the editor. Let’s go through the list of what’s available as of version 18.1 – to be …

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 …