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 …
What’s Wrong With My Code? We Try to Help You
I see questions like this on StackOverflow and related websites like, ALL THE TIME: I have some code, what’s wrong with it? Something I wish I could do, other than physically hold the person’s hand, is show them how our IDE tries to point them in the right direction of their syntax issues. But since I can’t do that, I’ll …
Quick Tip: Controlling how PL/SQL Errors are Shown
Remember, you only see the error messages in the log AFTER a compile. If you want to see the list of errors at any time, simply click on the ‘Errors’ page, or try compiling your program again. While we’re on this page, there’s lots and lots of cool things you can fiddle with here. For example, ‘SELECTED TEXT.’ And of …
30 SQL Developer Tips in 30 Days, Day 5: Connectivity Issues
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 …
How to View Errors for VIEWs in Oracle SQL Developer
I know, who has errors in their code? I don’t have errors because I don’t write code. But for the rest of you, it’s possible you have inherited someone else’s problem. And that problem might be an invalid VIEW. You can tell your view has a problem because of the big, sad, red X Oracle stores these errors in a …
How to Collect Debug Info for Oracle SQL Developer
In a perfect world, there would be no software bugs. Developers would always test their code. QA would find any scenarios and bugs the developers hadn’t already thought of. Regression tests would be complete and flawless. But alas, we can only afford to pay mere humans here, so we will have bugs from time to time. Or sometimes you are …
PLSQL Warning Messages in Oracle SQL Developer
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
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? …
ORA-03113: end-of-file on communication channel
My database crashed today. My ‘production’ database that is. The one I rely on for product demonstrations, that thing I do that Quest gives me money for. Pretty funny considering in the last few weeks my blogs have included such gems as: Are You a Real DBA – I argue that you are indeed NOT if you have not went …