Thank you for your response, But the broblem not in wrapping for procedure or function or package,

My problem that the wrap utility does not wrap the code if the code has a "CASE" statement,

For example : when PLSQL code has "CASE" the wrap does not work, And if i replace the "CASE" by "DECODE" Then the wrap utility will wrapp the code..

Thank you in advance,
And Sorry for any inconvenience.

Thank you for your response, But the broblem not in wrapping for procedure or function or package,

My problem that the wrap utility does not wrap the code if the code has a "CASE" statement,

For example : when PLSQL code has "CASE" statment the wrap utility does not do anything, And if i replaced the "CASE" by "DECODE" Then the wrap utility will wrapp the code.

can you help me please.

Thank you in advance,
And Sorry for any inconvenience.

The wrap version included with Oracle 9.2 has an extra parameter which can be used if new SQL features are used: edebug=wrap_new_sql See https://docs.oracle.com/cd/A97630_01/appdev.920/a96624/c_wrap.htm By the way, packages aren't harder to unwrap.

Thank you for your response,

But i have a wrapped code does not able to unwrap, but this code does not have a "CASE" statement for example, so it will not able to unwrap,

But if i add a "CASE" statment to PLSQL code for example, the wrap will not working.

If you can unwrap the below code so you right, But i am sure the below code will not unwrap.

My broblem is when the code has some reserved word the wrap does not working, with knowledge that i talking about the wrap code that you can not un-wrapping it,

Find below PLSQL code :


CREATE OR REPLACE PROCEDURE DBLOGMJ wrapped
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
7
8003000
1
4
0
3
7 DBLOGMJ:
5 DBLOG:
6 OTHERS:
0

0
0
17
2
0 1d 9a b4 55 6a a0 57
b3 b7 a0 53 4f b7 a6 9
a4 b1 11 68 4f 17 b5
17
2
0 3 4 14 15 19 1d 21
26 27 29 1 2d 2f 31 32
37 3b 3d 48 4c 4e 55
17
2
0 1 b 0 :2 1 :3 2 1 :2 10
5 17 :2 b :7 1
17
2
0 :2 1 0 :2 1 :3 c b :2 d e
:4 d :6 1
57
2
:4 0 1 :a 0 13 1 :4 0 3 :2 0
13 2 4 :2 0 2 :3 0 6 8
:2 0 9 0 3 12 3 :4 0 d
5 f 7 e d :2 0 10 9
:2 0 12 0 12 11 9 10 :6 0
13 0 2 4 12 15 :2 0 1
13 16 :6 0
b
2
:3 0 1 7 1 c 1 b 1
f
1
4
0
15
0
1
14
1
1
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0
2 0 1
0


Thank you in advance.
Best regards

Yes i have seen it, but i think my broblem does not clear enough for you,

From first and detail..
I have a function and this function has a simple query
as below :

"
SELECT 1
INTO VN_TEMP
FROM DUAL
WHERE P_ID IS NOT NULL;
"

And i wrap this function in way that doesn't able to unwarp, and it wrapped successfuly..

And after that i add a "CASE" as below :

"
SELECT CASE WHEN P_ID IS NOT NULL THEN 1 ELSE 0 END
INTO VN_TEMP
FROM DUAL;
"

It's not working after i added the "CASE" condition,

Note : I have used the wrap80.exe utility.

I wish it clear..

Thank you
And Sorry for any inconvenience

SQL> create or replace
  2  procedure my_proc wrapped
  3  a000000
  4  b2
  5  abcd
  6  abcd
  7  abcd
  8  abcd
  9  abcd
 10  abcd
 11  abcd
 12  abcd
 13  abcd
 14  abcd
 15  abcd
 16  abcd
 17  abcd
 18  abcd
 19  abcd
 20  7
 21  a3 c6
 22  JWRAY+TMPZjfSTily5+/YxtmE9Uwg0zwmMvhf3Q2JnOUuuZbMuXvfy/6waJCZ1isq6RRhrsI
 23  vfSsn6CCEwybdiM4ehmGOqO5BXrgZ3dhhNii3VyAhq1khbP3csz0xZn4OSRc1M0VGGTDayY1
 24  mOeD8ihwLZUc2PuRN9IKsyYaiGuu4cKsc7VJduNHxxMoRzM+Iw==
 25
 26  /

Procedure created.

SQL> exec my_proc(1)

PL/SQL procedure successfully completed.

Hello Sir,

Hope you are doing fine, i would like to ask if there is any update on this issue, for a refreshment and more clarification i would like to rephrase my question.

I have found a way to wrap PL-SQL code that cannot be un-wrapped in anyway, but I have an issue in this utility “Wrap80.exe”, this utility has some constraints on having some specific “reserved words, i.e. Case, Listagg … “ if any of these words exists in the code the utility does not function, but when I substitute any of these reserved words with another reserved word that is supported by the utility it works perfectly “ex. Substituting the (Case) with (Decode)”.

My question is there any oracle update, utility update or do you have any knowledge on how to overcome this problem without going through the hall code and changing the unsupported reserved words with the supported ones? As doing so would be time consuming and not that efficient.

Thank you in advance.

If i using the standard wrap facility then it will unwrapped..
I need to working on wrap80 to make the wrapped code will not unwrapped..

Did you have any update or idea ?