Home » SQL & PL/SQL » SQL & PL/SQL » log of a stored procedure (11 g)
log of a stored procedure [message #564670] Mon, 27 August 2012 07:49 Go to next message
primer2020
Messages: 32
Registered: August 2012
Member
Good morning guys,

How can I view the log of a stored procedure after it is called by an application?

Thank you



Re: log of a stored procedure [message #564671 is a reply to message #564670] Mon, 27 August 2012 08:00 Go to previous messageGo to next message
joy_division
Messages: 4504
Registered: February 2005
Location: East Coast USA
Senior Member
What is a log of a stored procedure?
Re: log of a stored procedure [message #564675 is a reply to message #564670] Mon, 27 August 2012 08:14 Go to previous messageGo to next message
dariyoosh
Messages: 532
Registered: March 2009
Location: Iran / France
Senior Member
[quote title=dariyoosh wrote on Mon, 27 August 2012 15:12]primer2020 wrote on Mon, 27 August 2012 14:49
Good morning guys,

How can I view the log of a stored procedure after it is called by an application?

Thank you




It depends on how your procedure provides log information (if it provides any), I mean, for example updating a log table upon its execution or updating a log file.

[Updated on: Mon, 27 August 2012 08:18]

Report message to a moderator

Re: log of a stored procedure [message #564678 is a reply to message #564670] Mon, 27 August 2012 08:49 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

What is this log?
Re: log of a stored procedure [message #564680 is a reply to message #564678] Mon, 27 August 2012 09:36 Go to previous messageGo to next message
primer2020
Messages: 32
Registered: August 2012
Member
A log file is file that stores any infomation about an execution of a code.
Re: log of a stored procedure [message #564681 is a reply to message #564680] Mon, 27 August 2012 09:48 Go to previous message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
>How can I view the log of a stored procedure after it is called by an application?
If the procedure does NOT explicitly write to its own log file, there is nothing to view.
Previous Topic: want to commit by changes in database after second transaction?
Next Topic: index was outside the bounds of array
Goto Forum:
  


Current Time: Sat Aug 30 00:12:00 CDT 2014

Total time taken to generate the page: 0.10049 seconds