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: Ariel <senseless_at_a.com>
Date: Tue, 28 Oct 2003 08:17:57 +0100
Message-ID: <2039-1067325483@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. Received on Tue Oct 28 2003 - 01:17:57 CST

Original text of this message

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