Results 1 to 2 of 2

Thread: Can't SELECT any CLOB fields

  1. Apr 15th, 2004, 02:33 PM #1
    MrGTI
    MrGTI is offline

    Thread Starter
    Frenzied Member MrGTI's Avatar
    Join Date
    Oct 2000
    Location
    Ontario, Canada
    Posts
    1,277

    Question Can't SELECT any CLOB fields

    I have an Oracle 8.1.74 database here at work. There is a table that has a CLOB datatype in it. If i try to select data from the table, including the CLOB field, i get an error: Data type is not supported.

    The SQL statement would look something like: SELECT RecordID, TextInClob FROM tbl_Sample

    I have searched the internet, and been unable to figure out how to retrieve the data in the CLOB field. Most answers point to something about Microsoft not supporting CLOB. But that seems a little too strange.

    Has anyone had any experiance in selecting CLOB data from Oracle? I'd love to get a viable solution.
    ~Peter

    Reply With Quote Reply With Quote
  2. Apr 20th, 2004, 08:41 AM #2
    MrGTI
    MrGTI is offline

    Thread Starter
    Frenzied Member MrGTI's Avatar
    Join Date
    Oct 2000
    Location
    Ontario, Canada
    Posts
    1,277

    Question

    No one else has ever encountered something like thus?
    ~Peter

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width