splits lines longer than 255

[deniskolesnikov]

Hi Marco,

I've encountered an unpleasant feature:
when I open a function/procedure from database into plsqldev's program window
it splits lines longer than 255.

sometimes it may cause errors
say there's a function:

create or replace function f_tmp return varchar2 is
result varchar2(30);
begin
result:=ltrim(replace('1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 11111111111111111111111111111','1',' '))| |to_char(sysdate,'dd.mm.yyyy hh:mi:ss');
return result;
end;

when it's opened from the database it becomes

create or replace function f_rm_tmp return varchar2 is
result varchar2(30);
begin
result:=ltrim(replace('1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 11111111111111111111111111111','1',' '))| |to_char(sysdate,'dd.mm.yyyy hh:m
i:ss');
return result;
end;

then if I press execute then the function in the database gets distorted
and when used produces the error:
ORA-01821: data format not recognized

plsqldev v.5.1.2.682;

Best Regards, Denis

 

[Marco Kalter]

We'll try to fix this. In the mean time you can only split these long lines yourself.

------------------
Marco Kalter
Allround Automations