DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Update CLOB from LONG

  1. 01-04-2007, 05:32 PM #1
    ssd
    ssd is offline Junior Member
    Join Date
    Jan 2007
    Posts
    5

    Update CLOB from LONG

    I'm using Oracle 8i.
    Source table contains LONG datatype and target table contains CLOB datatype.

    How do I Update target with source value?

    Thanks,
    ssd.
    Reply With Quote Reply With Quote
  2. 01-08-2007, 11:11 AM #2
    Srinivas_Sharma
    Srinivas_Sharma is offline Member
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    how about using TO_BLOB

    Insert into select id,TO_LOB(col_long) from

    Srini
    Reply With Quote Reply With Quote
  3. 01-08-2007, 12:28 PM #3
    ssd
    ssd is offline Junior Member
    Join Date
    Jan 2007
    Posts
    5
    My requirement is to Update the table. I understand that in Oracle 8i, only Dynamic SQL needs to be used.
    I am getting an error for following statement -
    EXECUTE IMMEDIATE 'Update clsl_account a set notes = (select to_lob(notes) from account where accountid = a.accountid)'

    Error encountered - ORA-00932: inconsistent datatypes.
    Reply With Quote Reply With Quote
  4. 01-09-2007, 08:08 AM #4
    Srinivas_Sharma
    Srinivas_Sharma is offline Member
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    hi

    check this....

    http://www.dba-oracle.com/oracle_new...data_types.htm

    Srini
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width