Hi,
I have a wrapped pl/sql package spec and body, in a .plb file. The wrapped file is created with Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production.
Using APEX 5.0.4 SQL Workshop > Script Editor, I am able to upload the file and run it as a script. It compiles the package and body properly, without error.
On a customer site, to which I connect with Citrix, where they are running APEX 5.1.0.00.45 and database 12.1.0.2.0, the same file, uploaded as a script, gets the following error for both the spec and body: ORA-24344: success with compilation error. I have tried adjusting the file upload text encoding so the file and the upload dialog match, tried adjusting the text so there are no line returns, etc. We have had no issues where Citrix caused problems with APEX.
When I look with the object browser at the package and spec, the error is: PLS-00753: malformed or corrupted wrapped unit.
The package can load and compile on the customer site with sql*plus.
Has anyone run into a similar problem?
Does anyone with 5.1 have a wrapped pkg they could try to see if it works?
Thanks,
Skip