View/Edit of wrapped programunit shows not all lines of code

[Theod]

Hi,

I'm using PLD Version 1398 and Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi.

View or Edit of an unit in the programeditor shows only the code of line 1 from user_sources.

So if the programunit is splitted in more then one lines at user_sources the compile fails with 'corrupted or malformated programunit'.

 

[Marco Kalter]

I'm not quite sure I understand. Can you give an example?

 

[Theod]

Hi,

what I want to say is:
The stored sourcecode can be queried from user_source and is there distributed in separate records numberd from 1 to x.

If I open an wrapped progamm unit from the browser for view or edit, then the window contains only a part of the complete program unit and it seems to be only the code contained in first record in user_source.

An compile of these fragement fails of course.

 

[Marco Kalter]

Can you send me such a wrapped source by e-mail?

 

[Theod]

Hi,

the mail is sent.

 

[ILay]

Hi, Theod!
Just curious: why and how You EDIT wrapped packages?

 

[Theod]

Hi,

I don't try to "edit", but to "view" and then "save as", or to "view" and "compile". For this the code should be complete.

 

[antony]

Is there any resolution to this issue? I am finding the same thing.
I am using version 8.0.0.1480 on Oracle 10.2.0.3

 

[Marco Kalter]

We'll check it out.

 

[MartinF]

Not really sure to understand the problem here,
but from what i know Wrap package can not be open for viewing because the basic of the wrapping is to prevent this kind of operation. Once wrapped, a package can not be unwrapped and you must have the real source code somewhere else.

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/wrap.htm#sthref3174

 

[antony]

I am updating a PLSQL package provided by a 3rd party supplier, which I only have wrapped versions of. Before updating this package, I need to take a backup of the existing version so that I can roll back the change if necessary.
The problem I have is that when I try to save the current version of the package, it doesn't include all of the wrapped text. This means that I can't back up the current version before updating it.