Long Raw in Oracle 8.0
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Long Raw in Oracle 8.0

  1. #1
    Join Date
    Dec 2001
    Posts
    5

    Long Raw in Oracle 8.0

    Hi,

    I need to copy LONG RAW value from one table to another.
    I get ORA-06502 PL/SQL: numeric or value error

    What is wrong here?

    Thank you all.
    Leah

    -----------------------

    declare
    v_IMAGE long raw;

    begin

    SELECT IMAGE
    INTO v_IMAGE
    FROM IMAGES
    WHERE IMAGE_ID = 4;

    UPDATE OTHER_IMAGES
    SET IMAGE = v_IMAGE
    WHERE IMAGE_ID = 4;

    end;

  2. #2
    Join Date
    Apr 2002
    Posts
    17
    Try to use some convertion of source Data for example to Character or hexadecimal data.
    Long raw fields stored in binary format and may be the problem is here. Try to use RAWTOHEX function

Posting Permissions

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


Click Here to Expand Forum to Full Width