Chr(13) in clob mistery ..

[nicofari]

Hi
I am using PL/SQL developer 8.0.4
I have this strange problem: a pl sql procedure has a clob OUT parameter.
Data are written in this parameter in a text delimited format.
The plsql code adds only a LF (chr(10)).
When I look at the output in a test window, though, I see a CR LF couple.
If I run the very same test script via sqlplus I see only LF.
So I guess: is PL/SQL developer adding a CR in some way ?
thanks
Bye
Nicola

 

[Marco Kalter]

Multi-line character strings will indeed have a cr/lf pair as an end-of-line marker on the Windows client. On the server there will only be a CR character as end-of-line marker.

 

[nicofari]

Hi
thanks for replying
But who is responsible for adding the missing CR character ?
It must be the plsql dev code, because from sqlplus I don't see it.
I ask because I have a java client which uses ojdbc driver and it shows the LF terminator only.
So I started investigating this discrepancy

 

[Marco Kalter]

This is indeed PL/SQL Developer behavior. You can go to Preferences > SQL Window and disable the "Read LF as CR/LF from database" option to control this behavior.

 

[nicofari]

Hi Marco
Perhaps was that option added in later version ?
I have the 8.0.4.1514 version and that flag does not show up.
Perhaps in this version that behaviour was hardcoded ?

 

[Marco Kalter]

Yes, that is indeed correct.

 

[nicofari]

Ok everything is clear now.
Thank you so much
Have a nice day
Nicola