Print Thread
Page 2 of 4 1 2 3 4
Re: remarks at the beginning of a package
#23474 09/27/06 03:57 AM
Joined: Feb 2004
Posts: 36
C
cmj Offline OP
Member
OP Offline
Member
C
Joined: Feb 2004
Posts: 36
I disagree. By removing that line all you did was remove a bunch of characters out of the remarks. If you remove that line but substitute the same number of characters for the stuff you removed, the problems still exist.

I'm still convinced that the error occurs when you exceed some magic number of characters in remarks preceding the actual code. Convince me otherwise.

Re: remarks at the beginning of a package
#23475 09/27/06 10:15 PM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
I tested again, and it is indeed a little bit more complicated. Any object type name in the header will cause this error. In this case the following 2 lines:

REM package body create for comp_err - description

REM 08/06/02 Jeff Moritze v27, added procedure for closing cursors.

I'm not sure why I didn't run into this yesterday, and perhaps you can confirm this.

Like I said, we'll fix it. I will send you this fix as soon as it's implemented.


Marco Kalter
Allround Automations
Re: remarks at the beginning of a package
#23476 09/28/06 12:39 AM
Joined: Feb 2004
Posts: 36
C
cmj Offline OP
Member
OP Offline
Member
C
Joined: Feb 2004
Posts: 36
Are you sure you carefully replaced each character you removed from the remarks with another character? You may replace it with any character you want.

Please be sure you understand my premise: The code I sent has one more character in the pre-code remarks than the "magic number" that causes failure. If you want, I will write some code to count those characters and find the number.

Remove one or more characters from the remarks in the code I sent and both problems go away. Add the character back in and the problems reappear. It doesn't matter a bit which character(s) you remove. If you are simply removing the characters "package body" or "procedure" without replacing them, then you have removed "one or more characters". Unless you have replaced characters removed with an equal number of characters and found that the code I sent works, you have not tested my premise.

Re: remarks at the beginning of a package
#23477 09/28/06 01:03 AM
Joined: Feb 2004
Posts: 36
C
cmj Offline OP
Member
OP Offline
Member
C
Joined: Feb 2004
Posts: 36
Now I have to apologize...sort of:

You are right in that if I substitute any character in the words "procedure" and "package" so they are not those special words, the body compiles with errors reported.

I am still right that if I leave those two words but delete any character from the REM lines, the body also compiles with errors reported.

I count 2938 characters in the REM lines.

I hope some developer looks at this and says "Ah Hah!" It sure looks like a very odd bug to me.

Re: remarks at the beginning of a package
#23478 09/28/06 08:01 PM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
Okay. We'll fix it.


Marco Kalter
Allround Automations
Re: remarks at the beginning of a package
#23479 10/03/06 01:04 AM
Joined: Sep 2004
Posts: 495
Dartmouth College, Hanover, NH...
Member
Offline
Member
Joined: Sep 2004
Posts: 495
Dartmouth College, Hanover, NH...
So I'm guessing this did not make it into 7.0.3?

I think I'm running into this or something very similar due to large comments in the package header.


Stew

"That's not a bug, it's a feature?"
Re: remarks at the beginning of a package
#23480 10/03/06 10:26 PM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
The original problem was fixed in 7.0.3, but there was an unrecognized problem when the comment text before the package includes keywords. This will be addressed shortly.


Marco Kalter
Allround Automations
Re: remarks at the beginning of a package
#23481 10/03/06 10:32 PM
Joined: Sep 2004
Posts: 495
Dartmouth College, Hanover, NH...
Member
Offline
Member
Joined: Sep 2004
Posts: 495
Dartmouth College, Hanover, NH...
Marco,

Sorry, what I should have said was that I'd noticed the initial problem before 7.0.3 but it seems to be working nicely now that I'm on 7.0.3. My apologies if someone thought I was saying they didn't fix the originally-reported bug.

Hopefully you can find and fix latest nuance quickly and release a patch for those suffering from it.

Best,


Stew

"That's not a bug, it's a feature?"
Re: remarks at the beginning of a package
#23482 05/03/07 11:14 PM
Joined: Jul 2004
Posts: 592
W
Member
Offline
Member
W
Joined: Jul 2004
Posts: 592
The problem referenced here used to be gone (in 7.0.3?), but now it seems like it's back in 7.1.

The problem is having a large number of (comment) characters at the beginning of a package body. When compiling that package, PLSQL Developer will instantly come back with "Compiled succesfully", but nothing will actually have been compiled.

If you get the number of characters just right (2828 characters in 59 lines, in my case), it will also truncate the package name shown in the tab of the program window.

Please look at (re-)fixing this problem. I was so happy when it was fixed before! smile

Re: remarks at the beginning of a package
#23483 05/04/07 03:56 PM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
If you can send me the package by e-mail, we'll check it out.


Marco Kalter
Allround Automations
Page 2 of 4 1 2 3 4

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.043s Queries: 13 (0.008s) Memory: 2.5612 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-04-29 15:39:39 UTC
Valid HTML 5 and Valid CSS