Re: Can wrap encode plain text?

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 Thu May 23 2002 - 16:55:25 CDT