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



Report message to a moderator

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: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
What is a log of a stored procedure?

Report message to a moderator

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: 538
Registered: March 2009
Location: 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?

Report message to a moderator

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.

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
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.

Report message to a moderator

Previous Topic: want to commit by changes in database after second transaction?
Next Topic: index was outside the bounds of array
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 01 07:37:48 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.