Claus Pedersen
Member³
I have a table with a column of type Varchar2(4000). I open the large data editor to paste some text into the column. Then I close the large data editor and post and commit the change. Now I open the large text data again and add some text at the end of the existing data. Again, I post and save.
I make a new query.
I open the large data editor again, now my text is truncated to 4000 characters (of course). But I get no error or warning from PLD that the amount of data was too large to fit into the column. Why? For smaller sized character fields, I get the error.
I lost some data in this process, so I said have some very bad words about PLD!
BTW, the large data editor reports that I have 4039 bytes of data. I beleive that this is because of the old bug that line feeds (chr(10) are translated into carriage return and line feed chr(13)+chr(10), which can be seen for instance in the hex editor.
I make a new query.
I open the large data editor again, now my text is truncated to 4000 characters (of course). But I get no error or warning from PLD that the amount of data was too large to fit into the column. Why? For smaller sized character fields, I get the error.
I lost some data in this process, so I said have some very bad words about PLD!
BTW, the large data editor reports that I have 4039 bytes of data. I beleive that this is because of the old bug that line feeds (chr(10) are translated into carriage return and line feed chr(13)+chr(10), which can be seen for instance in the hex editor.
