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

Crude but effective for small pieces of text

x := chr(123) || chr(65) || ...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."