Tag: error

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 […]

Similar Posts by Subject Areas: , , ,

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; […]

Similar Posts by Subject Areas: , , , ,

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 […]

Similar Posts by Subject Areas: , , ,

ORA-03113: end-of-file on communication channel

Don't ignore the warning signs. This crash was completely avoidable.

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 […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , ,