tag:blogger.com,1999:blog-8873109125023142810.post2997011828837106506..comments2024-03-28T16:58:51.302+05:30Comments on Let's Develop in Oracle: Alter VARCHAR2 Column To CLOBNimish Garghttp://www.blogger.com/profile/15795821721808548808noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8873109125023142810.post-54584582970835933622023-06-16T02:49:28.818+05:302023-06-16T02:49:28.818+05:30Hi , I did the above steps still facing issue whil...Hi , I did the above steps still facing issue while inserting more than 4000 chars data to the column: Error starting at line : 5 in command -<br />INSERT INTO testing (test_datatype)<br />VALUES ('More than 4000 chars data here')<br />Error at Command Line : 6 Column : 9<br />Error report -<br />SQL Error: ORA-01704: string literal too long<br />01704. 00000 - "string literal too long"<br />*Cause: The string literal is longer than 4000 characters.<br />*Action: Use a string literal of at most 4000 characters.<br /> Longer values may only be entered using bind variables.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-28175038089464086782013-03-13T23:00:54.332+05:302013-03-13T23:00:54.332+05:30Use below approach.
alter table modify long;
al...Use below approach.<br />alter table modify long;<br />alter table modify clob;Anonymousnoreply@blogger.com