RE: wrapping packages

Jared,

That is also my understanding of what wrap does - after all if the wrapped PL/SQL code is encrypted why do string literals appear within the wrapped output. And where do you specify the encryption key - you don't because wrap does not encrypt.

I'm not surprised that people think the wrap command encrypts the code seeing as authors likes Couchman and Marisetti use this language within "OCP Oracle9i Database Fundamentals I Exam Guide" page 96 and it is also stated in the PL/SQL User's Guide and Reference.

Cheers,
Craig.

-----Original Message-----
Sent: Monday, 22 September 2003 2:15 AM
To: Multiple recipients of list ORACLE-L

IIRC, 'wrap' does not actually encrypt the code.

Rather, it simply does a precompile on it and then stores the pcode in the database.

Jared

On Sat, 2003-09-20 at 14:29, Peter Gram wrote:
> Hi Pete
>
> I must point out that there must be a unwrap, since the Oracle database
> can run the wrapped pl/sql code :-)
>
> It is based on trust in Oracle cooperation / development.
>
> Some times it would make since to write the code in c/c++ since it
> harder to revers.
>
> Pete Finnigan wrote:
>
> >Hi
> >
> >Very true, but if there was the wrap process wouldn't be much use as
> >anyone could un wrap your code. But you are right the main reason to be
> >cautious is to not delete your source code locally.
> >
> >kind regards
> >
> >Pete
> >
> >In article <F001.005D0876.20030919154441_at_fatcity.com>, bhabani s pradhan
> ><bhabaniindia_at_rediffmail.com> writes
> >
> >
> >>one caution:
> >>
> >>there is no unwrap cmd/exe
> >>
> >>Regards
> >>
> >>
> >
> >
> >
>
> --
> Peter Gram, Miracle A/S
> Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696
> mail : peter.gram@MiracleAS.dk - http://MiracleAS.dk
>
> Upcoming events:
> DatabaseForum 2003, Lalandia 2-4 October
> Visit http://miracleas.dk/events/DBF2003/invitation.html
>
> Miracle Master Class with Tom Kyte, 12-14 January 2004
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Peter Gram
> INET: peter.gram_at_miracleas.dk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Craig Munday
  INET: Craig.Munday_at_ecard.com.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).