Re: Source of stored procedure (PL/SQL)

Ariel wrote:
>
> > >Can I:
> > >Step 1: compile stored proc
> > >Step 2: clear it source code?
> > >
> > >I know method of encyption of source code via wrap utility.
> > >
> > >Regards,
> > >Ariel.
> > >
> > >
> > Please rephrase Step 2 with more clarity and someone will be able to
> > help you.
> >
> > If you are asking what I suspect you are asking ... use
> > DBMS_METADATA.GET_DDL.
>
> Ok.
> In step 2 I want to clear text of source code this stored proc
> (after it's valid and compiled).
> DBMS_METADATA.GET_DDL for this object should return empty string or null.

To achieve step 2 you need to:

1. delete from sys.source$
2. hand in your Oracle license since you no longer have a supported database

hth
connor Received on Tue Oct 28 2003 - 05:45:27 CST