how to insert nclob data into a table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • deepuv04
    Recognized Expert New Member
    • Nov 2007
    • 227

    #1

    how to insert nclob data into a table

    Hi,
    i have table with nclob column. i want insert a row into table with large text. when i am trying to run insert statement getting error text too large >40000 charactes. i am using SQL Developper. i need to make this as a script and run on different servers.

    Thanks,
    Sandeep
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    Use plsql block ... see here
    http://asktom.oracle.com/pls/asktom/...D:388196216305

    Comment

    Working...