Wednesday, May 29, 2013

Wrap PL/SQL Source Code.

#############  Original Source Code ##########################

CREATE OR REPLACE PROCEDURE EXPORT_IMAGE_WRAPE (p_file  IN  VARCHAR2,
                                         p_blob  IN  BLOB)
AS LANGUAGE JAVA
NAME 'BlobHandler.ExportBlob(java.lang.String, oracle.sql.BLOB)';

########  Save This Source Code In Your D Or Any Other Drive Name wrape_input.sql ##########

Now Open Command Prompt (CMD)

Type the following:

C:\Documents and Settings\Rajib>wrap iname=D:\wrape_input.sql oname=D:\wrape_output.sql

PL/SQL Wrapper: Release 11.2.0.1.0- Production on Wed May 29 20:19:17 2013

Copyright (c) 1993, 2009, Oracle.  All rights reserved.

Processing D:\wrape_input.sql to D:\wrape_output.sql

C:\Documents and Settings\Rajib>

Now You can see Wrap File Name wrape_output.sql In Your D Drive.

####################  Output Source Code  ########################
   CREATE OR REPLACE PROCEDURE EXPORT_IMAGE_WRAPE wrapped
a000000
b2
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
7
cf eb
PzOCyr9qnqCDVJBb+N4Eu+anT1cwg43wNcusfI6iTBIYnR22JQK66p3OAqsOLvORscNsouup
K+B6vKxJuCu3nEf9YwFZBfK2aYwaIgT3C+aLTczzRpeKomCmUaZNzMY+/DKgRqpRdHIUtT7o
YezBVOZA6QkQnXDQKhVZmUe94blAXif4bfYAjP4QpYaiFRMQk4t+mi3A0rG8bXClM4qjM89X
3xPW1wYde7OCrg==

/
Now Execute this code in your Database.

Parameter :

iname >> Input Source File Name With Location.

oname >> Output Source File Name With Location.

No comments:

Post a Comment