Obfuscating PL/QL Code With DBMS_DDL Subprograms

[giridharn]

Hi All,

I was going through Obfuscation through DBMS_DDL Sub programs.

The below is the text provided in a pdf.

Running the wrap Utility
For example, assume that the wrap_test.sql file contains the following:

CREATE PROCEDURE wraptest IS
TYPE emp_tab IS TABLE OF employees%ROWTYPE INDEX BY PLS_INTEGER;
all_emps emp_tab;
BEGIN
SELECT * BULK COLLECT INTO all_emps FROM employees;
FOR i IN 1..10 LOOP
DBMS_OUTPUT.PUT_LINE('Emp Id: ' || all_emps(i).employee_id);
END LOOP;
END;
/
To wrap the file, run the following from the operating system prompt:
wrap iname=wrap_test.sql
The output of the wrap utility is similar to the following:
PL/SQL Wrapper: Release 10.2.0.0.0 on Tue Apr 26 16:47:39 2005
Copyright (c) 1993, 2005, Oracle. All rights reserved.
Processing wrap_test.sql to wrap_test.plb
If you view the contents of the wrap_test.plb text file, the first line is CREATE
PROCEDURE wraptest wrapped and the rest of the file contents is hidden.
You can run wrap_test.plb in SQL*Plus to execute the SQL statements in the file:
SQL> @wrap_test.plb
After the wrap_test.plb is run, you can execute the procedure that was created:
SQL> CALL wraptest();


The issue is
The conversion to .plb is done and even i can view it but when i try to run @wrap_test.plb, it says "SP2-0310: unable to open file "wrap_test.plb" "

It would be great if some one help me out.

Thanks in Advance
Giri

[davey23uk]

becuase the file doesnt exist in the directory you are running sqlplus from

[giridharn]

Thanks a Lot......Y didnt it occur 2 me.........