| wrap multiple files in a single command [message #123468] |
Mon, 13 June 2005 11:39  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai,
We need to wrap all our source code, which includes SP and packages so that no user could modify it.
is it possible to write a shell script which will wrap all the source objects?
There are around 200 files where those sp and packages reside
My qn is how to wrap all thos files in a single command
How do you propose we handle this problem?
very urgent.plz help out.
regards
bala
[Updated on: Tue, 14 June 2005 08:47] Report message to a moderator |
|
|
|
| Re: wrap multiple files in a single command [message #123772 is a reply to message #123468] |
Tue, 14 June 2005 15:38  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
You can make this any fancy!
Change it to fit your need.
I used a wildcard filter w*.sql.
bash-2.03$ cat wrap_sql
#!/usr/bin/bash
export ORACLE_HOME=/u01/app/oracle/product/9.2.0
export PATH=$ORACLE_HOME/bin:$PATH
ls -lrt /home/oracle/scr/ora/w*.sql | awk '{print $9}' > /tmp/wrap_sql.lst
cat /tmp/wrap_sql.lst | while read file_name
do
echo converting $file_name
wrap iname=$file_name
done
touch /tmp/wrap_sql.lst
bash-2.03$ wrap_sql
converting /home/oracle/scr/ora/w1.sql
PL/SQL Wrapper: Release 9.2.0.4.0- 64bit Production on Tue Jun 14 15:31:27 2005
Copyright (c) Oracle Corporation 1993, 2001. All Rights Reserved.
Processing /home/oracle/scr/ora/w1.sql to w1.plb
converting /home/oracle/scr/ora/wade.sql
PL/SQL Wrapper: Release 9.2.0.4.0- 64bit Production on Tue Jun 14 15:31:27 2005
Copyright (c) Oracle Corporation 1993, 2001. All Rights Reserved.
Processing /home/oracle/scr/ora/wade.sql to wade.plb
converting /home/oracle/scr/ora/write_log.sql
PL/SQL Wrapper: Release 9.2.0.4.0- 64bit Production on Tue Jun 14 15:31:27 2005
Copyright (c) Oracle Corporation 1993, 2001. All Rights Reserved.
Processing /home/oracle/scr/ora/write_log.sql to write_log.plb
[Updated on: Tue, 14 June 2005 15:39] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
