You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SQL> desc abcd
Name Null? Type
-------- -------- -------------
ID NOT NULL NUMBER(38)
NAME VARCHAR2(80)
IMAG BLOB
DESCR CLOB
Insert statement:
SQL> insert into abcd select rownum, dbms_random.string('p',60), UTL_RAW.CAST_TO_RAW('This is a test insert into blob column'), to_clob('This is a test insert into clob column') from xmltable('1 to 10');
Source DB inserted data:
SQL> select * from abcd where id=10;
ID NAME IMAG DESCR
---------- -------------------- ------------------------------ ------------------------------
10 :"(mjs`j""NsacxJ^N W 546869732069732061207465737420 This is a test insert into clo
B?qvqClLJ>H;+_#2Ka9E 696E7365727420696E746F20626C6F b column
g9[B%vAiwe%?~&%,Fu:5 6220636F6C756D6E
Hi @vnykmr36 . Did you have chance to find a way to reproduce the issue?
I have tested CLOB and all works good. To fix it I need either the redo log files or a list of steps to reproduce it.
If the problem is not possible to reproduce, I will close the ticket and we can open it back when the problem appears.
Table desc:
Insert statement:
Source DB inserted data:
Payload in the file:
The issue is true for all 10 rows inserted.
The text was updated successfully, but these errors were encountered: