Re: Audit - Stored procedure creation

  • From: Adam Musch <ahmusch@xxxxxxxxx>
  • To: niktek2005@xxxxxxxxx
  • Date: Tue, 1 Apr 2014 23:42:52 -0500

Yes - if you had run AUDIT PROCEDURE before creation.  Or if you'd SET ECHO
ON and saved the log file from the deployment from SQL*Plus or equivalent.


On Tue, Apr 1, 2014 at 11:38 PM, Nik Tek <niktek2005@xxxxxxxxx> wrote:

> Hi,
>
> Is there a way to find that a certain stored procedure was ever created in
> Oracle?
> When I deploy the schema from a file, I'm missing few SPs, I wanted to
> know if the stored procedure was ever tried to deploy.
>
>
> Thank you
> Nik
>



-- 
Adam Musch
ahmusch@xxxxxxxxx

Other related posts: