dbms messaging in a package

Posted on 2011-03-25
Medium Priority
Last Modified: 2012-05-11

I wanted to capture the time start , time end and time elapsed in a oracle package and sometimes even on what stage the program is running and how long (estimated) it would take to complete - so that it is user friendly when someone invokes the package and waits until it is done - is there any standards on this and anyone developed any template that can used quickly in a short turnaround for coding and testing? If yes can you guys share?
Question by:mahjag
  • 3
  • 2
LVL 74

Accepted Solution

sdstuber earned 200 total points
ID: 35218215

does exactly that
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35218217
I don't know of anything you can buy to do this.

Typically I just create my own 'timing' table.  Then I can add any rows at any stage I want.  Then report on it however I choose.
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35218222
>>does exactly that

I stand corrected.
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

LVL 74

Expert Comment

ID: 35218247
set_session_longops fills in the data

you query status and time remaining from v$session_longops

Author Comment

ID: 35221781
can application developer have access to v$session?
LVL 74

Expert Comment

ID: 35222200
yes, and also to v$session_longops.

you'll have to ask your dba to grant you access though

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question