Long Raw to Blob Conversion help required

From: Oneil <oneill_at_hotmail.com>
Date: 14 Aug 2001 08:53:42 -0700
Message-ID: <2a1f66da.0108140753.289f4211_at_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" 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?

Thanks in advance
Oneil Received on Tue Aug 14 2001 - 17:53:42 CEST