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 …

30 SQL Developer Tips in 30 Days, Day 5: Connectivity Issues

thatjeffsmith SQL Developer 27 Comments

The most frequently posted question when it comes to Oracle Database, HAS to be around connectivity. If you’re just starting out working with the database, not being able to connect to said database has to be a very frustrating experience. And for some reason our error messages tend to confuse folks even further. And not everyone has a DBA they …

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 …

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? …