Re: Howto create a serverside CLOB for a large string-result?

"Dr. Thomas Frankewitsch" <franket_at_medsnt01.uni-muenster.de> writes:

> hello,
>
> concerning oracle 8i.
>
> as far as I know clobs can only be derived from a existing one.
>
> But it might be possible to create one out of "nothing"?
>
> I need one as an result :-), must use thin-odbc. and haven't found any
> documentation in the oracle-examples or docu.
>
> Does anybody know where Oracle has hidden this documentation ???
> thanks in advance
>
> thomas

Here is the method I used via OCI:

• insert empty lob handle
• select for update same lob handle
• use OCILobWrite to write data to lob

I based this on the OCI documentation. Like you, I searched for a long time for a way to insert a non-empty lob thinking such a device *must* exist.

--
Kelly R. Burkhart
kburk_at_sky.net

Just enjoy the Ozzy and keep your mouth shut

• George Plimpton (on SNL)