Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

problem with wrapping code

916872Feb 11 2012 — edited Feb 13 2012
Hi, 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==

/
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2012
Added on Feb 11 2012
36 comments
2,507 views