Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CLOB datatype

Status
Not open for further replies.
des0929

des0929

Technical User
Nov 11, 2003
6
US
I'm trying to ODBC connect MS Access to my Oracle database. I have problems with tables that have CLOB format fields. How can I get around this problem? Can a view be created that can change the datatype of the CLOB field(s) into a VARCHAR format? If so, how is this done...Oracle function?

Thanks.
 
Status
Not open for further replies.

Similar threads

EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
1K
carp
carp
kernal
  • Locked
  • Question
Is there any way to write a select statement for distinct when there is a CLOB field? 2
Replies
4
Views
650
john parker
john parker
slicendice
  • Locked
  • Question
Using REPLACE on CLOB causes increase in CACHE_LOBS...
Replies
1
Views
665
Thargy
Thargy
kv444
  • Locked
  • Question
CLOB
Replies
1
Views
153
Dagon
Dagon
kv444
  • Locked
  • Question
Convertvarchar2 to clob
Replies
2
Views
199
SantaMufasa
SantaMufasa

Part and Inventory Search

Sponsor

Back
Top