Print Thread
Page 1 of 2 1 2
Error getting wrapped packages text
#51568 06/02/15 12:35 PM
Joined: Sep 2005
Posts: 86
A
Ameen Offline OP
Member
OP Offline
Member
A
Joined: Sep 2005
Posts: 86
Hi
there is an error when getting "wrapped" packages text.
the error exist in :
1. view package body menu
2. Edit package body menu
3. Compare User Objects.

I queried DBA_SOURCE and I noticed that PLD get only the first record of the package body from DBA_SOURCE.

example :
select t.text from dba_source t
where t.owner='MAINT'
and t.name='SEND_MAT'
and t.type='PACKAGE BODY'
order by t.line;

the result:
record 1:
PACKAGE BODY SEND_MAT wrapped
0
abcd
abcd
...

record 2:
3b 3d 3c
3e 3d 3f 3e
40 3f 41 40
...

the result is 2 records but PLD get the first one only, causing error when recompile the package or when take it to a second database after comparing objects.

I tried pld v 10 and it is the same error too.
This only appears for WRAPPED packages not for normal packages.

I did not have a chance to test it over package header as all the packages I have are less than 4000 byte long. but I suspect it is the same error exist for package header too.
Please check it and correct the retrieval of the text as a combination of all records from DBA_SOURCE (i.e record1 || record2) don't use end-of-line character between the records.

I hope I am helping you to achieve bug free product wink

Re: Error getting wrapped packages text
Ameen #51570 06/02/15 12:51 PM
Joined: Sep 2005
Posts: 86
A
Ameen Offline OP
Member
OP Offline
Member
A
Joined: Sep 2005
Posts: 86
The error exist in (export user objects) too.

Re: Error getting wrapped packages text
Ameen #51589 06/07/15 02:57 PM
Joined: Sep 2005
Posts: 86
A
Ameen Offline OP
Member
OP Offline
Member
A
Joined: Sep 2005
Posts: 86
Marco ! ... cry

Re: Error getting wrapped packages text
Ameen #51595 06/08/15 09:01 AM
Joined: Aug 1999
Posts: 22,225
Member
Offline
Member
Joined: Aug 1999
Posts: 22,225
We're looking into this.


Marco Kalter
Allround Automations
Re: Error getting wrapped packages text
Marco Kalter #51630 06/10/15 08:35 PM
Joined: Sep 2005
Posts: 86
A
Ameen Offline OP
Member
OP Offline
Member
A
Joined: Sep 2005
Posts: 86
I know it is not included in 11.03, but please keep it in your mind and fix it as soon as possible because it is very critical.

I confirm the bug exist for both package specification and package body code.

Thanks.

Re: Error getting wrapped packages text
Ameen #52052 09/02/15 08:36 AM
Joined: Sep 2005
Posts: 86
A
Ameen Offline OP
Member
OP Offline
Member
A
Joined: Sep 2005
Posts: 86
Sadly this error still exists in v11.04 frown

Re: Error getting wrapped packages text
Ameen #52057 09/02/15 02:52 PM
Joined: Dec 2005
Posts: 132
Leoben,Austria
D
Member
Offline
Member
D
Joined: Dec 2005
Posts: 132
Leoben,Austria
I am also interested in a solution for this problem.

Re: Error getting wrapped packages text
Dezsoe Kados #52640 12/04/15 08:37 PM
Joined: Jul 2009
Posts: 11
Richmond, VA, USA
Member
Offline
Member
Joined: Jul 2009
Posts: 11
Richmond, VA, USA
I have also been bitten by this, but thanks for a great product.


Rich Hull
PSD 14, or a Beta (usually the latest, even if I forget to update this)
Re: Error getting wrapped packages text
Rich Hull #53120 02/14/16 11:38 AM
Joined: Sep 2005
Posts: 86
A
Ameen Offline OP
Member
OP Offline
Member
A
Joined: Sep 2005
Posts: 86
Sadly this error still exists in v11.05 !!! frown

Re: Error getting wrapped packages text
Ameen #53198 02/25/16 05:49 PM
Joined: Sep 2005
Posts: 86
A
Ameen Offline OP
Member
OP Offline
Member
A
Joined: Sep 2005
Posts: 86
Just refresh the post...hope to be seen...

Page 1 of 2 1 2

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.055s Queries: 16 (0.020s) Memory: 2.5589 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-05-29 10:15:34 UTC
Valid HTML 5 and Valid CSS