Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    japan
    Posts
    35

    Unanswered: How to display Image stored in Long Raw Columns

    I having problem on read image stored in long raw and convert back to binary format.

    Btw. I know the command for open BFILE is DBMS_LOB.FILEISOPEN(variable); but I don't have the command to open LONG RAW.

    Kindly give some advices.

    Thanks.

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    LOBs use locators to point to the data, so you need to use special commands to work with them. (Actually, Oracle should have made the quirks of LOBs transparent to users, but that's another story.)

    LONG and LONG RAW store the data in the column itself, just as if you were using VARCHAR2, NUMBER, or DATE formats. You don't need to use special commands to open LONG RAW columns before selecting the data.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

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