How to get green bug (debug) icon on a stored procedure?

debugging oracle10g toad
user1883066 picture user1883066 · Dec 6, 2012 · Viewed 13.5k times · Source

I have Oracle 10.5 installed on my system.

I created a stored procedure using Toad. It is running successfully.

I observed that there are different icons for stored procedures in Toad:

  1. Red cross (error in procedure)
  2. White rectangle (new procedure)
  3. Green bug (debugged procedure)

My procedure has the white rectangle icon. I want to change it to the green bug icon.

I found online that I have to run the stored procedure in debug mode. I ran it but it didn't change the icon.

How I can get the green bug icon for my stored procedure?

Answer

René Nyffenegger picture René Nyffenegger · Dec 6, 2012

The green bug indicates that the stored procedure (or package) was compiled with debug information and can be debugged. In order to create the necessary debug information, you need to (re-)compile your stored procedure with

alter procedure PROCNAME compile debug;

Replace PROCNAME with the actual name of your stored procedure.

Related questions

How do I remedy "The breakpoint will not currently be hit. No symbols have been loaded for this document." warning?

A C# desktop application on the express edition worked, but then it didn't work 5 seconds later. I tried the following: Ensure debug configuration, debug flag, and full debug information are set on all assemblies. Delete all bin and obj folders …

Read More
How can I write to the console in PHP?

Is it possible write a string or log into the console? What I mean Just like in JSP, if we print something like system.out.println("some"), it will be there at the console, not at a page.

Read More
How can I connect to Android with ADB over TCP?

I am attempting to debug an application on a Motorola Droid, but I am having some difficulty connecting to the device via USB. My development server is a Windows 7 64-bit VM running in Hyper-V, and so I cannot connect directly …

Read More