Debugging in SQL Developer

Session ID:

1104

Presenter(s):

Lewis Cunningham

SQL Developer, formerly Raptor, has until recently been shipped as an add on to the Oracle database. With Oracle 11g, Oracle has chosen to make SQL Developer the preferred development tool for Oracle developers and has phased out the GUI version of SQL Plus.

SQL Developer 3.0, in addition to robust programming tools, provides a very powerful source level debugger for PL/SQL. In addition to stepping through PL/SQL code, called local debugging, SQL Developer also allows remote debugging. In a remote debugging session, the developer sets up a listener so that procedures called by an external client application can be debugged.

In this presentation, I will walk through the steps of compiling with debug turned on, stepping through a locally running procedure and I will follow up with a remote debugging session executed from a client application.

Do you need to know exactly what is being executed when your application runs and you need to debugging it while the application is running? Or do you need to debug batch jobs that can't be called from the command line due to complex setup scenarios? Through out your DBMS_OUTPUT and use SQL Developer's remote debugging facility.

Find out how easy debugging can be, with SQL Developer.

Schedule info

Time slot:

17 July 12:30 - 13:25

Room:

Virtual Room # 100

Session Objectives:

Attendees will learn the steps to debug both local and remote PL/SQL programs.

Track/Stream:

Database Development - Oracle

Category:

Training Session

Group:

How-To (Step by Step Guide)

Session Length:

60 Minutes

Status:

Accepted

Target Audience:

All

Posted by lewiscunningham Mar 20, 2011

Stalk VirtaThon @

Like VirtaThon?

LIVE Activity Stream

Ha Dinh Thang signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace

3 hours ago
Yohan signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace

7 hours ago
nilanjan signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace

8 hours ago
HOARAU signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace

8 hours ago
Hany Abdo signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace

9 hours ago
Jimmy Coran signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace

11 hours ago
AMIT DUTTA signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace

11 hours ago
shyamkumar signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace

1 day ago

Quick Poll

Are you excited about the advent of VirtaThon?

Top Members

Scroll To Top

About BrainSurface | The Collaborative ConnectSpace for Oracle, Java & MySQL Professionals

BrainSurface is the most Powerful, Advanced & Extensible ConnectSpace for Oracle, Java & MySQL professionals and is built on and driven by the following themes:

Next-Generation Social Networking

State-of-the-Art IT Collaboration

BrainSurface is broadly aimed at sharing, collaborating and reusing all the edges of technology and technical/functional knowledge that, we come accross in our professional lives within the generalized realm of the Oracle, Java & MySQL communities. BrainSurface is the FIRST of its kind in bringing Social Networking and ALL known collaborative paradigms under one roof for this very purpose: Online Virtual Conferencing, Webinars & Webcasts, Social Collaboration, Document Publishing, Blogging in all its variant forms, Videos, Discussions, Forums, Job Repository, Project Management and a whole lot more. All Collaboration and Social Networking components within BrainSurface are bleeding-edge, intuitive and feature-rich. Best of all: membership at BrainSurface is 100% FREE!

Disclaimer: VirtaThon and BrainSurface are not affiliated or supported by Oracle Corporation and its affiliates/subsidiaries. Oracle, Java, MySQL and others are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.