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

In 8.1.5 there is a 'temporary lob' feature, prior to that a LOB could only exist as a database object. This may be the cause of the problem.

BTW - I think the OCI calls are in place to do something like:

        insert into table (empty_lob())
        returning lob_locator_col into :variable

(Sorry, OCI isn't my strong point - this is a hint, not a correct sample, but the principle of using RETURNING to avoid an extra round-trip should be supported).

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Kelly Burkhart wrote in message ...
>"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)
Received on Wed Oct 06 1999 - 03:58:51 CDT