Re: CLOB to VARCHAR2 -- (ver 9i)

On 18 Sep 2006 15:12:44 -0700, matt_at_mailinator.com wrote:

>
>Sybrand Bakker wrote:
>> http://asktom.oracle.com/pls/ask/f?p=4950:8:13266295515100393693::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:18909757644296
>
>im not sure what youre referring to in that link. can you be more
>specific?
>
>

Please search for ora-22859 on that page (if not asked too much) or empty_lob() where Tom Kyte explains in *8i* you couldn't INSERT a LOB directly. In 9i you can.

>> Please *ALWAYS* post your version in ordet to get *accurate* answers
>> and not waste peoples time.
>
>i am confused -- does my "Subject:" line not say its version 9? it does
>for me.
>
>
>> Oracle 8i, BTW, is desupported for more than a year.
>
>but im not on 8. im using 9, according to the IT folks here. but a side
>note on the time frame -- big orgs can be *very* slow to upgrade
>database servers, for many valid reasons.
>
>
>matt

Those reasons are usually political and nonsensical. One reason I know of, is the third party app vendor still doesn't support the most current version, even not several *years* after it was released.
The other reasons are always of the form 'Yeah, but we are going to replace this app next year...', which of course never happens.

--
Sybrand Bakker, Senior Oracle DBA