Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    6

    Unanswered: Loading LongRaw data into Database

    I have a helpfile which gets data from the Backend and in the back end, it is stored as datatype = 'Long Raw'.
    Now, i would like to make some changes to this data. How do I make changes to this ? Iam able to see only junk in this particular field when I view it...

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How do I make changes to this ?
    The same way as it was created in the first place.
    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.

  3. #3
    Join Date
    Aug 2004
    Posts
    6
    The whole problem is i was not the one who created this. If I did, Im sure I would be able to update it as well!!!

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    If the data is "text" type, you can use the sys.utl_raw package
    and the substr procedure within the utl_raw package ...
    or cast_to_varchar

    HTH
    Gregg

  5. #5
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    Quote Originally Posted by neerajav
    I have a helpfile which gets data from the Backend and in the back end, it is stored as datatype = 'Long Raw'.
    Now, i would like to make some changes to this data. How do I make changes to this ? Iam able to see only junk in this particular field when I view it...

    You can use UPDATE for the LONG RAW. Example:

    create table TEST (
    MAP_KEY char(42) ,
    UPDATE_JOB_ID number (8),
    MAP LONG RAW)
    tablespace ts_seg02
    pctfree 30 pctused 60
    storage ( initial 2097143808
    next 2097143808
    minextents 2 maxextents 121 pctincrease 0 );

    update TEST set MAP_KEY=:b0,UPDATE_JOB_ID=:b1,MAP=:b2
    where ROWID=:b3 ;


    Hope that helps,

    clio_usa - OCP 8/8i/9i DBA

Posting Permissions

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