IlyaLibov
asked on
Storage procedures compilation history.
Is there a way to check compilation history in toad or oracle pl/sql when compiling stored procedures.
David VanZandt
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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,
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,