What does this Oracle SQL Developer icon mean on my stored procedure?

oracle stored-procedures oracle-sqldeveloper
jeph perro picture jeph perro · Nov 12, 2010 · Viewed 24.6k times · Source

I've been creating stored procedures using Oracle SQL developer.

For some reason, one of the icons does not contain a green circle. What gives? What does this non-green icon mean?

alt text

Answer

Justin Cave picture Justin Cave · Nov 12, 2010

I believe the green circle you're referring to is actually a green bug icon. That indicates that the procedure has been compiled for debug.

If you are editing a stored procedure in SQL Developer, there should be a gear icon at the top of the edit screen that you use to compile the procedure. If you click the arrow to expand that, you should get options to compile the procedure or to compile for debug. If you select "Compile for Debug", you'll get the green bug icon. If you select "Compile", the bug icon will go away.

Related questions

Run Stored Procedure in SQL Developer?

I am trying to run a stored procedure that has multiple in and out paramaters. The procedure can only be viewed in my Connections panel by navigating Other Users | | Packages | | If I right click , the menu items are "Order Members …

Read More
How can I use Oracle SQL developer to run stored procedures?

* EDIT6: * This is what ended up working for me (from accepted answer): var ret1 number var tran_cnt number var msg_cnt number var rc refcursor exec :tran_cnt := 0 exec :msg_cnt := 123 exec get_account(Vret_val => :ret1, Vtran_…

Read More
What do you use to write and edit stored procedures in Oracle?

There are many options for editing and writing Stored Procedures in Oracle; what is the best tool for you and why? (one tool per answer.)

Read More