Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Question about WRAPPED packages and procedures
You don't mention OS + Oracle version, here's an example from Oracle EE 8.0.5 on
NT4, also
I found it in the Oracle doc.
SYNTAX: $ORACLE_HOME/bin/wrap iname=<path>/xxxxxxx.sql [oname=<path>/xxxxxxxx.plb]
EXAMPLE: C:\>wrap80 INAME=C:\JMS_Support
PL/SQL Wrapper: Release 8.0.5.1.0 - Production on Thu Feb 11 09:39:35 1999
Copyright (c) Oracle Corporation 1993, 1994, 1995, 1996, 1997. All rights reserved
Processing C:\JMS_Support.sql to JMS_Support.plb
C:\>
You'll have to store your UN-wrapped souurce separately.
Regards
Lars Bo
COREBIT SYAP/TPI AG, Switzerland
John0725 wrote:
> Hi.
>
> How do I WRAP a stored procedure or package?
>
> Also, once WRAPPED, is there any way to unwrap it, or would I need to keep a
> separate copy of the source somewhere?
>
> I have looked in my oracle manual but can't seem to find it.
>
> Please respond by email. john0725_at_aol.com
>
> Thanks in advance!
>
> --John
--
Lars Bo Vanting
Siemens Business Services AG
Aemmenmattstrasse 43
CH-3123 Belp, Switzerland
Phone: +41 31 818 6149 Fax: +41 31 818 6140 Mobile: +41 79 691 7487