Re: HOWTO create BinaryStream-Results for XML?

From: CRAY_k <crayk_at_hotmail.com>
Date: Wed, 29 Sep 1999 15:39:53 GMT
Message-ID: <dpqI3.437$pa1.2309147@nnrp1.proxad.net>

For writing in LONG fields tou can't do that with PL/SQL, you must use OCI API !!
But !
you can also use CLOB fields (Ora8) to store XML and retrieve the value with classic SQL queries but these (you driver or application) must support CLOB fields (in ...OCI 8)

OCI is the only way !

Thomas Frankewitsch <franket_at_medsnt01.uni-muenster.de> wrote in message news:7ssh4g$ka4$1_at_redenix.uni-muenster.de...
> Hi all,
>
> just a question I've spent a lot of time...
>
> I want to create a stored procedure which should be a XML result.
> I've tried this with a java-procedure loaded into the server.
>
> Ther I've found, that Varchr2 is to small :-(, using an Java-Outputstream
> (registered in PL-SQL as LONG) is also cutted after 4096 chars :-(((((
>
> It shoudl be possibel to do that, because ORDIMG can!
>
> I didn't want to use the web-Server-module which can handle longer
> outputstreams, I'just want to send back a long, long stream of about 20
KB!
>
> thanks in advance
>
> thoma
>
>
Received on Wed Sep 29 1999 - 10:39:53 CDT