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

Thread: long RAW datatype

  1. #1
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104

    long RAW datatype

    Hi Guys,
    I have a table which contains a long RAW type as field. I have queried
    the same table using select statement i got the following error.

    Inconsistent Data type.
    Could any one tell me the query for this.

    Regards,
    Sudheer

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    refer to dbms_lob

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    what is the select statement

    somethink like

    desc t1;

    col1 int
    col2 long

    select col1 from t1 where col2 like '%yadda yadda yadda%';

    If so you will have to do this through pl/sql

    look on asktom.oracle.com and search on "where long select datatype"
    for clues on how to do this.

    steve
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    Dec 2002
    Location
    India & Australia
    Posts
    68

    long RAW datatype

    Hi Sudheer,

    It seems you are chasing the lengthy type of data to be extracted from database through the querying.
    but,

    Mind it the sql buffer is first and foremost thing to be placed your return result.

    usage of DBMS_ related packages will only adequate to get the result.

    If you are working in Chennai TCS or any top MNC co. then you will get the manuals for viewing.

    since the data cannot be viewed as it consists like a several pages to tresspass so better be it fix in to the file allocation.

    Hope your previous query (CLOB) also fix the same note.

    Hope you achive this

    VAST

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