Re: how to retrieve a part of a blob column?

From: Mike Ault <mikerault_at_earthlink.net>
Date: 3 Jul 2002 05:35:22 -0700
Message-ID: <37fab3ab.0207030435.599e99b9@posting.google.com>

James,

Have you looked at DBMS_LOB? It allows substringing. Take a looks at the Lazyscripts group on Yahoo, I have posted a simple set of examples using JAVA and PL/SQL to load, retrieve and view lob data:

Post message: LazyScripts_at_yahoogroups.com Subscribe: LazyScripts-subscribe_at_yahoogroups.com Unsubscribe: LazyScripts-unsubscribe_at_yahoogroups.com List owner: LazyScripts-owner_at_yahoogroups.com

Mike Ault
"james" <james_at_963.net> wrote in message news:<aftr38$25je$1_at_mail.cn99.com>...
> hello all!
> this is my problem:
> i want to retrieve a blob column on a oracle 8i server throw a very slow
> link,even retrieve just one row is very difficult.
> how can i retreive only a part of that blob column times after times and
> assemble them locally? i don't know if i can do this and what is the syntax.
>
> thanks a lot.
Received on Wed Jul 03 2002 - 07:35:22 CDT