• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Converting Long Datatype in Oracle

Ktulu

Ktulu

Diamond Member
How do you convert this? It's driving me nuts. We're running Oracle 10.2.0.3 and I'm using PL/SQL Developer to query. It's seems almost impossible to do any reporting from this field.
 
Well, Long's are depricated in favor of the Character Long Objects, or CLOB. Thus you should convert the long to a clob if you can. As for reporting on that field... Its a field used for storing documents from what I understand similar to a mysql BLOB. What type of report are you trying to do?
 
Originally posted by: hooflung
Well, Long's are depricated in favor of the Character Long Objects, or CLOB. Thus you should convert the long to a clob if you can. As for reporting on that field... Its a field used for storing documents from what I understand similar to a mysql BLOB. What type of report are you trying to do?
Click to expand...

We're using Oracle Reports as our main reporting tool and Oracle HTP package for web reporting.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top