All in a page.
http://arjudba.blogspot.com/2008/06/...pe-to-lob.html
Regards,
Arju,
http://arjudba.blogspot.com

On Aug 7, 4:04*am, Arju <a_a... (AT) yahoo (DOT) co.uk> wrote:
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.

On Aug 7, 4:04*am, Arju <a_a... (AT) yahoo (DOT) co.uk> wrote:
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.

On Aug 7, 4:04*am, Arju <a_a... (AT) yahoo (DOT) co.uk> wrote:
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.

On Aug 7, 4:04*am, Arju <a_a... (AT) yahoo (DOT) co.uk> wrote:
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.

On Aug 7, 6:04*am, Arju <a_a... (AT) yahoo (DOT) co.uk> wrote:
No, it isn't, as this jumble of text doesn't address the question at
hand. The OP asked about BLOB conversion of LONGs, not CLOB
conversion. I find nothing on that page which answers the question as
posted.



David Fitzjarrell

On Aug 7, 6:04*am, Arju <a_a... (AT) yahoo (DOT) co.uk> wrote:
No, it isn't, as this jumble of text doesn't address the question at
hand. The OP asked about BLOB conversion of LONGs, not CLOB
conversion. I find nothing on that page which answers the question as
posted.



David Fitzjarrell

On Aug 7, 6:04*am, Arju <a_a... (AT) yahoo (DOT) co.uk> wrote:
No, it isn't, as this jumble of text doesn't address the question at
hand. The OP asked about BLOB conversion of LONGs, not CLOB
conversion. I find nothing on that page which answers the question as
posted.



David Fitzjarrell

On Aug 7, 6:04*am, Arju <a_a... (AT) yahoo (DOT) co.uk> wrote:
No, it isn't, as this jumble of text doesn't address the question at
hand. The OP asked about BLOB conversion of LONGs, not CLOB
conversion. I find nothing on that page which answers the question as
posted.



David Fitzjarrell