DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Clob Datatype

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    Clob Datatype

    Hi all,

    I have to convert a table from Access and this table had more than 200 columns and out of this these 200 columns, I have four column that has more than 4000 character. Any way, I used SQLLDR to load this table to Oracle and since I am lazy and the table will be dropped once I got the data so I create the table in Oracle with all CLOB datatype since I don't know which columns had more than 4000 characters in the .csv file.

    Any way, the data was convert to Oracle now and I like to view it so I did a select statement and I got the following error:

    One of the Oracle 8.x Datatype is not supported in the context of current statement.

  2. #2
    Join Date
    Oct 2002
    Location
    Boston
    Posts
    7
    you can use dbms_lob package syntex for selecting the clob field's substr.

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