Home » SQL & PL/SQL » SQL & PL/SQL » open source tool for debugging
open source tool for debugging [message #228172] Mon, 02 April 2007 00:01 Go to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
i am looking for a good open source tool, where i can
debug my plsql packages, but sql developer from oracle doesnt
seem to work, i am facing problems with toad, and i badly need
one debugging tool, can anyone suggest me one?

Re: open source tool for debugging [message #228174 is a reply to message #228172] Mon, 02 April 2007 00:14 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
vi?
Re: open source tool for debugging [message #228258 is a reply to message #228172] Mon, 02 April 2007 05:09 Go to previous messageGo to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
sorry i did not get you
Re: open source tool for debugging [message #228263 is a reply to message #228258] Mon, 02 April 2007 05:44 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
VI is an editor used by UNIX users. If on MS Windows, you'd use NOTEPAD.

In other words: any (free) editor is a free tool for debugging.
Re: open source tool for debugging [message #228269 is a reply to message #228263] Mon, 02 April 2007 06:10 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
TOAD Is a useful tools for debugging
Re: open source tool for debugging [message #228271 is a reply to message #228172] Mon, 02 April 2007 06:21 Go to previous messageGo to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
i am encountering problems with toad, after i provide the
values for my in parameters for the procedures,

so i am looking for a tool wherein i can give in parameters,
and debug to find out the flow in the procedure

i cannot do that in notepad
Re: open source tool for debugging [message #228272 is a reply to message #228269] Mon, 02 April 2007 06:22 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
True, but is far from being an Open Source product.
Re: open source tool for debugging [message #228275 is a reply to message #228272] Mon, 02 April 2007 06:29 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So you do have TOAD, but don't know how to use it? That's another story. Perhaps you should learn a little bit more about TOAD's Procedure Editor and its debugging features.

BTW, you CAN do that in notepad (but is painful).
Re: open source tool for debugging [message #228286 is a reply to message #228275] Mon, 02 April 2007 07:43 Go to previous messageGo to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
i do know how to use toad, what i am doing is,

debug - set parameters - i give parameters, select the
checkbox output OUT args....

then ok, then i press F8, it shows the following message

"do you want to compile referenced objects with debug
information? This process can take several seconds"

i choose No...i get the following message


ORA-12638- Credential Retrieval Failed.

This is frustating, as I rely on toad to know about the
funtionalities of complex packages

anyone can help me ?




Re: open source tool for debugging [message #228291 is a reply to message #228286] Mon, 02 April 2007 07:54 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Did you Google for that message? This thread offers a solution that seems to have helped a lot of people
Re: open source tool for debugging [message #228296 is a reply to message #228286] Mon, 02 April 2007 08:04 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
IF I understood you correctly, you keep pressing "No" when TOAD asks you to compile referenced objects with debug information.

So, what happens when you press "Yes" instead?
Re: open source tool for debugging [message #228303 is a reply to message #228296] Mon, 02 April 2007 08:29 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
No, Littlefoot, he very clearly said 'i do know how to use toad', so it can't be that!
Re: open source tool for debugging [message #229487 is a reply to message #228172] Sun, 08 April 2007 23:21 Go to previous messageGo to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
littlefoot

if i say yes, it says alter package username.packagename compile
debug

ora - 04043 object that packagename does not exist

Re: open source tool for debugging [message #229488 is a reply to message #228172] Sun, 08 April 2007 23:28 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Privs acquired via roles do NOT apply within PL/SQL procedures.

What is/are the most likely causes of ORA-04043 error?


P.S.
Google is your friend but only if you actually use GOOGLE!
Previous Topic: ways to load time dimension
Next Topic: retrieving image from database
Goto Forum:
  


Current Time: Thu Feb 06 22:31:23 CST 2025