Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Source of stored procedure (PL/SQL)

Re: Source of stored procedure (PL/SQL)

From: <sybrandb_at_yahoo.com>
Date: 28 Oct 2003 03:52:51 -0800
Message-ID: <a1d154f4.0310280352.29c79ae8@posting.google.com>


"Ariel" <senseless_at_a.com> wrote in message news:<2039-1067325483_at_213.17.192.18>...
> > >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.

This is not possible and using wrap is sufficient protection.

Sybrand Bakker
Senior Oracle DBA Received on Tue Oct 28 2003 - 05:52:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US