sabhhrt
November 2nd, 2004, 06:15 PM
Hello all,
I have a problem and hope you gurus can help me.
I have a table with a column as a varchar2(4000 char). When i update a row in this table with a huge text from sqlplus, it inserts a bunch of newlines randomly in the text. This is giving me problems coz i am not expecting newlines (Chr(13)+chr(10)).
But if i update the same from an application in VB, this is alright. This only happens when i run the same update query from sqlplus.
Now my question is: Can i by changing some "SET" parameters on sqlplus avoid this? I hope somebody can throw some light into this issue. I have tried so many options but none worked. Can you gurus please help me out.
Thanks
Sam
I have a problem and hope you gurus can help me.
I have a table with a column as a varchar2(4000 char). When i update a row in this table with a huge text from sqlplus, it inserts a bunch of newlines randomly in the text. This is giving me problems coz i am not expecting newlines (Chr(13)+chr(10)).
But if i update the same from an application in VB, this is alright. This only happens when i run the same update query from sqlplus.
Now my question is: Can i by changing some "SET" parameters on sqlplus avoid this? I hope somebody can throw some light into this issue. I have tried so many options but none worked. Can you gurus please help me out.
Thanks
Sam