Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1028
  • Last Modified:

Storage procedures compilation history.

Is there a way to check compilation history in toad or oracle pl/sql when compiling stored procedures.
0
IlyaLibov
Asked:
IlyaLibov
1 Solution
 
DavidSenior Oracle Database AdministratorCommented:
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
 
Geert GruwezOracle dbaCommented:
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
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now