Home » SQL & PL/SQL » SQL & PL/SQL » Regarding Procedure Troubleshooting (ORACLE 9i)
Regarding Procedure Troubleshooting [message #434499] Wed, 09 December 2009 06:58 Go to next message
Messages: 3
Registered: December 2009
Location: Chennai
Junior Member

Dear members,

I am creating one big procedure with succesfully.
while i am running it has struced/stopped.how can i know what is the problem.

it is one interview question.

interviewer asked me how can you troubleshoot the procedure,can you please help me on this..

Re: Regarding Procedure Troubleshooting [message #434502 is a reply to message #434499] Wed, 09 December 2009 07:17 Go to previous messageGo to next message
Michel Cadot
Messages: 63912
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Instrumentalize your code and activate the trace.

Some pointers that will give an idea:

Re: Regarding Procedure Troubleshooting [message #434548 is a reply to message #434499] Wed, 09 December 2009 12:11 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
The correct answer:
You should never have created one big procedure, but you should have split it into multiple smaller procedures that are packaged.
Previous Topic: extract pairs
Next Topic: Sql to get previous row value
Goto Forum:

Current Time: Sun Oct 23 15:55:27 CDT 2016

Total time taken to generate the page: 0.04571 seconds