Session ID: 
1104
Presenter(s): 

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

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

Stalk VirtaThon @

  • Facebook Page: 113995341985805
  • FeedBurner: brainsurface
  • Twitter: brainsurface
  • YouTube: brainsurface
  • External Link: paper.li/brainsurface/oracle-java-headlines

Like VirtaThon?

Joomla Templates and Joomla Extensions by JoomlaVision.Com

LIVE Activity Stream

  • Krishna signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 11 hours ago
  • salhi signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 1 day ago
  • Mohammed signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 2 days ago
  • nemo3000 signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 3 days ago
  • jack signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 3 days ago
 

Who's Online?

0 users and 401 guests online

Quick Poll

Are you excited about the advent of VirtaThon?