OraFAQ Forum: SQL & PL/SQL » Procedure execution issue and trace

Home » SQL & PL/SQL » SQL & PL/SQL » Procedure execution issue and trace (11g r2, linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Procedure execution issue and trace [message #657352]

Mon, 07 November 2016 06:52

qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan

Member

Hi Experts,

I have a procedure which almost works fine but sometimes it fails.

How can I know the reason of failure or what statement in procedure cause failure?

Can tracing provide such info?

Kindly guide.

Regards,
Qazi

Report message to a moderator

Re: Procedure execution issue and trace [message #657353 is a reply to message #657352]

Mon, 07 November 2016 06:55

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

When it fails, how does it fail? Does it raise any exception? If so, which one?

Report message to a moderator

Re: Procedure execution issue and trace [message #657366 is a reply to message #657352]

Mon, 07 November 2016 09:34

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

In addition to Littefoot's questions:
Under what conditions does it fail?

Report message to a moderator

Re: Procedure execution issue and trace [message #657412 is a reply to message #657366]

Tue, 08 November 2016 03:34

qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan

Member

Thanks Littlefoot and Pablolee for your kind response.
I have as much knowledge about this procdure as I have provided you.

Can we trace steps of procedure execution to know which step was cause of failure? and how?

Regards,
Qazi

Report message to a moderator

Re: Procedure execution issue and trace [message #657413 is a reply to message #657412]

Tue, 08 November 2016 03:40

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you can modify the code and execute the procedure with SQL*Plus, then you cn add some dbms_output.put_line statements in the code.

Report message to a moderator

Re: Procedure execution issue and trace [message #657414 is a reply to message #657412]

Tue, 08 November 2016 03:42

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

So you don't know what the code is?
You don't know if it raises an error or not?

If it's raising an error then the error message will tell you which line the error occurred on

Report message to a moderator