Re: Can wrap encode plain text?

But even that leaves all the text in clear view.

It is quite annoying, all variable names and types remain visible, many assignments are easy to read, cursor declarations are visible, etc.

If you write a piece of PL/SQL whose contents are proprietary, it's difficult to hide how they function without making it unintelligible e.g. using meaningless variables, etc.

Andy

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3CED654C.BC2A6F3A_at_exesolutions.com...
> Yong Huang wrote:
>
> > I want to hide plain text in my PL/SQL code. If it's in
> > dbms_out.put[_line] or htp.print, the text won't be "wrapped"; instead
> > there's just a "1" in front of the line. The following test is done on
> > 9i and 8.1.7.2:
> >
> > $ cat q.sql
> > create or replace procedure p
> > is
> > begin
> > dbms_output.put('This is trade secret!');
> > end;
> > /
> >
> > $ wrap iname=q.sql
> >
> > PL/SQL Wrapper: Release 9.0.1.0.0- Production on Thu May 23 16:20:55
> > 2002
> >
> > Copyright (c) Oracle Corporation 1993, 2001. All Rights Reserved.
> >
> > Processing q.sql to q.plb
> > $ grep "trade secret" q.plb
> > 1This is trade secret!:
> >
> > Is there a way to encode that text?
> >
> > Yong Huang
>
> a := 'a';
> w := 'secret';
> x := 'This ';
> y := 'is ';
> z := 'trade ';
>
> dbms_output.put_line(x||y||a||'z||w);
>
> Though I can't imagine why you would have DBMS_OUTPUT in any production
> code.
>
> Daniel Morgan
>
Received on Fri May 24 2002 - 02:54:34 CDT