Home » RDBMS Server » Performance Tuning » Debug Procedure (Oracle 11g,Win7 32 bit)
Debug Procedure [message #617228] Thu, 26 June 2014 05:55 Go to next message
Xandot
Messages: 111
Registered: January 2014
Location: India
Senior Member
Hello,

I want to debug my procedure without any help of tool ...how can i do this ....
Is there any command line utility present in oracle ??


Thanks,
Xandot
Re: Debug Procedure [message #617229 is a reply to message #617228] Thu, 26 June 2014 06:01 Go to previous messageGo to next message
ThomasG
Messages: 3100
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well, SQL*Plus is a commmand line utility AND a tool. Wink

Would that qualify?

Re: Debug Procedure [message #617230 is a reply to message #617229] Thu, 26 June 2014 06:05 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2444
Registered: May 2013
Location: World Wide on the Web
Senior Member
Using SQL Developer

Well without any tool, you need skills and expertise.
Re: Debug Procedure [message #617235 is a reply to message #617229] Thu, 26 June 2014 06:39 Go to previous messageGo to next message
Xandot
Messages: 111
Registered: January 2014
Location: India
Senior Member
Yes ThomasG....

So what step can i follow for debug the procedure in sql*plus ....

Re: Debug Procedure [message #617236 is a reply to message #617230] Thu, 26 June 2014 06:40 Go to previous messageGo to next message
Xandot
Messages: 111
Registered: January 2014
Location: India
Senior Member
Hey Lalit ,

Can you please give me any idea or hints....??

[Updated on: Thu, 26 June 2014 06:40]

Report message to a moderator

Re: Debug Procedure [message #617237 is a reply to message #617235] Thu, 26 June 2014 06:41 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2444
Registered: May 2013
Location: World Wide on the Web
Senior Member
Xandot wrote on Thu, 26 June 2014 17:09
So what step can i follow for debug the procedure in sql*plus ....


To start with :
sho err
Re: Debug Procedure [message #617238 is a reply to message #617236] Thu, 26 June 2014 06:42 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2444
Registered: May 2013
Location: World Wide on the Web
Senior Member
Xandot wrote on Thu, 26 June 2014 17:10
Hey Lalit ,

Can you please give me any idea or hints....??



The link which I posted above has everything that you need.
Re: Debug Procedure [message #617251 is a reply to message #617238] Thu, 26 June 2014 09:10 Go to previous message
Xandot
Messages: 111
Registered: January 2014
Location: India
Senior Member
Thank a lot lalit ....
Previous Topic: Materialized View- Delay refresh
Next Topic: UNDO Setup Issue
Goto Forum:
  


Current Time: Mon Oct 20 22:15:00 CDT 2014

Total time taken to generate the page: 0.25254 seconds