Re: Convert LONG (not RAW) to BLOB?
From: Spiggy Topes <ubik_at_shaw.ca>
Date: Mon, 11 Aug 2008 10:19:58 -0700 (PDT)
Message-ID: <0a7e6d81-1fe5-45e3-9757-8a5a704bcd71@l33g2000pri.googlegroups.com>
Date: Mon, 11 Aug 2008 10:19:58 -0700 (PDT)
Message-ID: <0a7e6d81-1fe5-45e3-9757-8a5a704bcd71@l33g2000pri.googlegroups.com>
On Aug 7, 4:04 am, Arju <a_a..._at_yahoo.co.uk> wrote:
> All in a page.http://arjudba.blogspot.com/2008/06/how-to-convert-long-data-type-to-...
> Regards,
> Arju,http://arjudba.blogspot.com
The first two methods I'm fairly sure don't work for converting a LONG to a BLOB - to a CLOB, no problem, but I have binary data stashed in a LONG, which these methods will not handle. Method 3 appears to rely on to_lob also, so that's out. I suspect method 4, which you say implicitly calls a LONG_TO_LOB function will baulk in the same way. Thanks for the suggestions, but I think the earlier suggestion which transcribes without relying on built-in functions is the only way that will work for me. Received on Mon Aug 11 2008 - 12:19:58 CDT