A package procedure fails to show in the code contents

[era]

Hi,

We have encountered that a procedure declaration from package body, disappers from the code contents when a query is very (very very) long. We've managed to "fix" this if we add at the beging of the procedure line with "null;".

Is this a known issue ? Is it a limitation of plssql developer / is it a bug ?

Regards,
Era

 

[Marco Kalter]

Can you send me a source file to reproduce this?

 

[era]

no problem, I will send it on sunday

 

[era]

Hi,

After doing some investigation it seems that the problem is not in the length of a query, but in my opnion , related to the parse .
When i use the word "end" inside a query, the code contents disappear (after recompiling).

What I mean can be seen in the procedure test_prc below.
If I will change "'a' end" to "'a' end2" - the code content will reappear.

do you think this will be fixed in the future ?

-------------------------------
create or replace package era2 is
procedure era_prc;
end;
/

create or replace package body era2 is
procedure era_prc is
begin
insert into era_schd select sysdate from dual;
commit;
end;

procedure test_prc is
a varchar2(5);
begin
select 'a' end
into a
from dual;
end test_prc;
end;

 

[patch]

This looks a lot like the Treeviewbug issue.

 

[era]

Hi,

It does seem like the treeviewbug.
When do you think it will be fixed (which version)?

 

[Marco van der Linden]

Then again, you might want to consider to stop using SQL and/or PL/SQL keywords as identifiers/aliases...............

 

[era]

This is the workaround we will do, but the psql code runs without error, therefore I thought I should ask...
So I guess no bug fix in the near fututre ?