Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354

    Unanswered: Adding data to a CLOB column

    Need some help adding data into a CLOB column. I know how to get the data out of the column, however, I can't seem to find a way to update the table column when I have to save changes back into the column... have done various searches on Google and technet to no avail...

    I know this doesn't work (first thing I tried), but it's essentially what I'm trying to accomplish:
    Code:
    UPDATE myTable SET clob_column = my_clob_variable WHERE id=1234;
    Thanks in advance your ideas and suggestions!
    JoeB
    save disk space, use smaller fonts

  2. #2
    Join Date
    Nov 2004
    Location
    Hyderabad
    Posts
    1
    Use DBMS_LOB package inorder to acheive this.

    Refer the example at http://oracle.ittoolbox.com/code/d.asp?d=3091&a=s

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •