A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Reading BLOB fields from the database
Migrated From Jforum.net
Joined: Apr 22, 2012
Sep 03, 2008 09:46:13
I would like to read post text directly from the database with SQL. However, since the field is a blob the result is not readable.
I have tried the following SQL:
select utl_raw.cast_to_varchar2(dbms_lob.substr(j.post_text, 100, 1)) from JFORUM_POSTS_TEXT j; select utl_raw.cast_to_varchar2(j.post_text) from JFORUM_POSTS_TEXT j;
Does anyone have a clue?
I'm using JForum 2.1.6 with Oracle 9.
[originally posted on jforum.net by frankern]
I agree. Here's the link:
subject: Reading BLOB fields from the database
reading BLOB type
Quartz Scheduler - CPU Intesive/DB Intensive
java.sql.sqlexception data size bigger than max size for this type
Search doesn't work after the crash
Any datatype to store files of size greater than 20k
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014