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: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 28 Oct 2003 07:12:25 -0800
Message-ID: <1067353962.331265@yasure>


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

Impossible. If you need help obscuring code, and WRAP isn't sufficient hire a consultant
to show you how.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Tue Oct 28 2003 - 09:12:25 CST

Original text of this message

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