PLSQL code editor wrapping lines permanently

[stephan vos]

Hi,

We had a issue recently where it seems that the editor wrapped various lines in a procedure permanently.

For example:
v_generated_id:=dw_apex_generate_utl.create_generated_script (pi_app_user,'',pi_zip_file_name,pi_comment,pi_apex_values_id,v_id,'ETL Deploy',$$PLSQL_UNIT);
became
v_generated_id:=dw_apex_generate_utl.create_generated_script (pi_app_user,'',pi_zip_file_name,pi_comment,pi_apex_values_id,v_id,'ETL

Deploy',$$PLSQL_UNIT);
As you can see the string was split in the middle with 0D0A0D0A (CRLFCRLF) causing other issues when other code is trying to get records from a table where value is "ETL Deploy".

Is there a reason why this could happen? I know wrapping setting under preferences will wrap lines longer than the current editor window width but it should not be permanent...
This can cause major issues if it happens in the middle of strings.

Thanks.

 

[Marco Kalter]

PL/SQL Developer will never change your PL/SQL code, unless you are using a function like the PL/SQL Beautifier. If this were to happen it would be a bug. If you have a reproducible scenario, please let me know.