-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|