Home » RDBMS Server » Server Administration » stored procedure problem
stored procedure problem [message #64073] Mon, 13 December 2004 02:11 Go to next message
sachin tom
Messages: 3
Registered: December 2004
Junior Member
respected Sir

how do i know, how many times my stored procedure has executed.

thank you

Report message to a moderator

Re: stored procedure problem [message #64081 is a reply to message #64073] Mon, 13 December 2004 12:25 Go to previous message
Frank Naude
Messages: 4596
Registered: April 1998
Senior Member
Hi,

You will have to track it manually. Add some code to
your procedure to update a tracking table each time
it executes.

You may also want to consider using an Autonomous
Transaction if you plan on COMMITting the tracking
table independently of the main transaction.

Best regards.

Frank

Report message to a moderator

Previous Topic: stored procedure problem
Next Topic: how to convert oracle table data into text file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 14 18:00:52 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.