Re: Audit - Stored procedure creation

  • From: Nik Tek <niktek2005@xxxxxxxxx>
  • To: Adam Musch <ahmusch@xxxxxxxxx>
  • Date: Tue, 1 Apr 2014 21:44:35 -0700

Thank you Adam!
Can you please provide an example or pointers?

Thank you
Nik


On Tue, Apr 1, 2014 at 9:42 PM, Adam Musch <ahmusch@xxxxxxxxx> wrote:

> 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: