Search within JForum
Register / Login
Win a copy of
Pro Spring MVC with WebFlux: Web Development in Spring Framework 5 and Spring Boot 2
this week in the
this forum made possible by our volunteer staff, including ...
Stephan van Hulst
Reading BLOB fields from the database
Migrated From Jforum.net
posted 12 years ago
Number of slices to send:
Optional 'thank-you' note:
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]
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
Boost this thread!
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