problem with wrapping code
916872Feb 11 2012 — edited Feb 13 2012Hi, I have a problem.
I created a pl/sql procedure or function and I want wrap it.
When I generate it, i got error message:
"Function created with compilation errors"
I create other one, what is very simple:
______________________________________________________
create or replace function testing_wrap (p_param in NUMBER)
return varchar2
IS
v_param VARCHAR2(3);
begin
SELECT CASE p_param
WHEN 1 THEN 'A'
WHEN 2 THEN 'B'
WHEN 3 THEN 'C'
WHEN 4 THEN 'D'
WHEN 5 THEN 'E'
END INTO v_param from dual;
return v_param;
end;
/
______________________________________________________
in the OS level:
______________________________________________________
wrap iname=test.sql oname=test.out
PL/SQL Wrapper: Release 10.2.0.1.0- Production on Szo Febr. 11 10:11:16 2012
Copyright (c) 1993, 2004, Oracle. All rights reserved.
Processing test.sql to test.out
______________________________________________________
When I run the first code everithyng is OK, but the wraped file is not correct..
______________________________________________________
SQL> @test.sql;
Function created
SQL> @test.out;
Warning: Function created with compilation errors
SQL>
______________________________________________________
Can help anybody me?
the wrapped code is:
create or replace function testing_wrap wrapped
a000000
aa
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
8
107 ef
bvTlE/1HL4bnKF56dk831J/aBMMwgy5y2svWfHQ5j/8iAsTdVBGwWRsE4zY5raGIvrVi7OU+
ARjSQ/72WgZRD0TvB30Bep9jsgrNtFreNZYW3ilU9mlKoUQPGkhmed1bZ8+NaK4KYWFQCH1E
ph1yimZ7nl9jONE1aElvNAvkekBHoS5r/+QLeX+/LYAt+eBy4H6bcKciIByxx+01sUT4ogMC
Tkq7nAJ2YcR4RHci8w==
/