Re: wrap80 with wild card characters

A copy of this was sent to Anurag Minocha <anurag_at_synergy-infotech.com> (if that email address didn't require changing) On Fri, 03 Dec 1999 14:45:33 +0530, you wrote:

>Hi,
>I am trying to encrypt my stored procedure with wrap utility given by
>oracle. The problem is that the iname paramater does not take wild char
>characters (*) and i have approx two hundred stored procedures and
>encrypting them is also a headache.
>I tried to create a batch file but it doent run in that also.
>
>Does anybody know how i can encrypt my procedures without taking much
>pain.
>I have to do this regularly to send to our clients.
>
>Thanks
>Anurag
>
>also reply at
>anurag_at_synergy-infotech.com

use the for command:

C:\WINNT\Profiles\tkyte\Desktop\test>for %f in ( *.sql ) do wrap iname=%f

C:\WINNT\Profiles\tkyte\Desktop\test>wrap iname=test.sql

PL/SQL Wrapper: Release 8.1.5.0.0 - Production on Fri Dec 03 09:25:04 1999

Copyright (c) Oracle Corporation 1993, 1994, 1995, 1996, 1997, 1998, 1999. All rights reserved

Processing test.sql to test.plb

C:\WINNT\Profiles\tkyte\Desktop\test>wrap iname=test1.sql

PL/SQL Wrapper: Release 8.1.5.0.0 - Production on Fri Dec 03 09:25:04 1999

Copyright (c) Oracle Corporation 1993, 1994, 1995, 1996, 1997, 1998, 1999. All rights reserved

Processing test1.sql to test1.plb

C:\WINNT\Profiles\tkyte\Desktop\test>wrap iname=test2.sql

PL/SQL Wrapper: Release 8.1.5.0.0 - Production on Fri Dec 03 09:25:05 1999

Copyright (c) Oracle Corporation 1993, 1994, 1995, 1996, 1997, 1998, 1999. All rights reserved

Processing test2.sql to test2.plb

C:\WINNT\Profiles\tkyte\Desktop\test>

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Dec 03 1999 - 08:25:46 CST