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
koduru.a
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..

Thanks.
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: 63804
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:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:54174245781686
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:12836314571537
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:10445025326812
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2102951300346243605

Regards
Michel
Re: Regarding Procedure Troubleshooting [message #434548 is a reply to message #434499] Wed, 09 December 2009 12:11 Go to previous message
Frank
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: Mon Sep 26 19:39:24 CDT 2016

Total time taken to generate the page: 0.11384 seconds