Re: Audit - Stored procedure creation

From: Nik Tek <niktek2005_at_gmail.com>
Date: Tue, 1 Apr 2014 21:44:35 -0700
Message-ID: <CAHySzWUE+uNxdPcK-zf42ZD_xN_Wb9w0+KnzvZo7Xrj_EKaE_Q_at_mail.gmail.com>

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_at_gmail.com> 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_at_gmail.com> 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_at_gmail.com
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 02 2014 - 06:44:35 CEST