patch
Member³
When writing code it's really nice to have the code contents displayed in the left treeview. There seems to be something wrong with the parser used. If you use a reserved word in your cursor for instance, then the code will compile and it will be runnable, but the code contents are not displayed.
spec:
body:
If the alias begin in the cursor is renamed to start then the treeview is returned.
Is this something that can be changed? This doesn't take away the fact that using a reserved word as an alias should be avoided, since the field cannot be used in the PL/SQL Code.
Kindest regards,
Patrick
spec:
Code:
create or replace package treeviewbug is
-- Author : Patrick Barel
-- Created : 18-5-2009
-- Purpose : displaying a codetreeview bug
procedure showbug;
end treeviewbug;
body:
Code:
create or replace package body treeviewbug is
-- Function and procedure implementations
procedure showbug
is
cursor thebug
is
select sysdate as begin
, sysdate as eind
from dual;
l_thebug thebug%rowtype;
begin
open thebug;
fetch thebug into l_thebug;
dbms_output.put_line(to_char(l_thebug.eind, 'DDMMYYYY'));
close thebug;
end showbug;
end treeviewbug;
If the alias begin in the cursor is renamed to start then the treeview is returned.
Is this something that can be changed? This doesn't take away the fact that using a reserved word as an alias should be avoided, since the field cannot be used in the PL/SQL Code.
Kindest regards,
Patrick