Long Raw to Blob Conversions

From: Oneil <oneilL_at_hotmail.com>
Date: 15 Aug 2001 09:55:54 -0700
Message-ID: <59be96ba.0108150855.7977362a@posting.google.com>

Hi, we're currently working on a long raw to blob conversion.

Table A (field_1 char(30), field_2 char(30), field_blob blob) PK on field_1 and field_2

Table B (field_1 char(30), field_2 char(30), field_longraw LONG RAW) PK on field_1, field_2

If I run an insert statement such as:

---

Insert into A ( field_1, field_2, field_blob) select field_1, field_2, to_lob(field_longraw) from B
where B.field_1 = 'XXXX'
and B.field_2 = 'YYYY'

---

It seems to work fine for 1 or 2 records.

However, should I increase the width of the where clause, say add another table into the equation
Table C ( field_1 char(30), field_2 char(30), field_3 char(30) PK on field_1, field_2
and change my query to

---

Insert into A ( field_1, field_2, field_3) select B.field_1, B.field_2, to_lob(B.field_longraw) from B, C
where B.field_1 = C.field_1
and B.field_2 = C.field_2

---

The query executes but inserts NULL values into the BLOB column "field_blob" for all matched records in table A.

Has anyone encountered a problem like this or am I doing something wrong? Is there any other alternative solution to this problem? It does not seem to work with large result sets (>300,000 records)

Thanks in advance
Oneil Received on Wed Aug 15 2001 - 11:55:54 CDT