Improve company productivity with a Business Account.Sign Up

x
?
Solved

Storage procedures compilation history.

Posted on 2013-11-21
3
Medium Priority
?
1,218 Views
Last Modified: 2013-11-30
Is there a way to check compilation history in toad or oracle pl/sql when compiling stored procedures.
0
Comment
Question by:IlyaLibov
3 Comments
 
LVL 23

Expert Comment

by:David
ID: 39667170
As in "results of x at timestamp were successful"? No there is not.  I might consider an OS trap to write to a flat file when the compile step finished.   What are you trying to accomplish?
0
 
LVL 39

Accepted Solution

by:
Geert G earned 1500 total points
ID: 39668640
you can link Toad to a VCS (Version control System) like SubVersion, Team Foundation, ...
This allows you to check out a procedure, modify it and check it back in.

The VCS system will then contain all the history.

Open the help in Toad and look for Team coding
You'll find lots of entries of the different possibilities.

if you have the connection open in toad, you could hit F8 in the editor: SQL Recall
All the last entries you did should be there
0
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 39673903
we can see the compilation errors by using the dba_errors or user_errors dict views but history will not be there as already mentioned.

select * from dba_errors
where owner = 'CRMCA'
and name = 'PKGLW_ENTITLEMENTS_OLD'
order by sequence

You can probably have a job or script which can run before compiling any procedure to extract the errors output from this view and insert into some log/history table for your reference.

Thanks,
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

595 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