Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2010
    Posts
    1

    Question Unanswered: copy a long raw/ long data from one column to another Blob column in the same table

    Hi ,
    Can anyone suggest how to copy a long raw/ long data from one column to another Blob column in the same table .
    I have tried
    UPDATE TEST1 SET LONGRAW_TEMP = TO_LOB(LONGRAW);
    but this dosent work .. gives an error (guess TO_LOB cannot be used with update query)
    Also tried
    INSERT INTO TEST1 (LONGRAW_TEMP) (SELECT (TO_LOB(LONGRAW))FROM TEST1);
    but it enters duplicate rows .

    Any help is appreciated .

    Thanks ,
    Ankita

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Ask Tom "how to select and insert a long type col..."

    "A Long / long raw that is greater then 32k cannot be inserted into another table via
    plsql. You must use C or VB or Java or someother language for that. The SQLPLUS copy
    command works as well."
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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