ORA-00997 8i trigger long raw problem

Hi,
Have a table that i need to populate with 1 record of an identical type from another table in an after insert using a trigger. Usually no problem at all except am forced into using and keeping a field which is a LONG RAW type that now generates an ORA-00997 error. It is all text stored in a LONG RAW format.

The table the record needs to be inserted INTO looks like ... RFQ_ID VARCHAR2 15
RFQ_LINE NUMBER 0
TYPE CHAR 1
BITS LONG RAW
BITS_LENGTH NUMBER 0 The data the table comes FROM looks like this.

PART VARCHAR2 30
PART_LINE NUMBER 0
TYPE CHAR 1
BITS LONG RAW
BITS_LENGTH NUMBER 0 Here is an example of the BITS data

REFER TO APPENDIX "A" (QAF-101 REV. 6) FOR INTERPRETATION OF THE QUALITY REQUIREMENTS SHOWN BELOW:
INSPECTION CODE: D
M/P INDEX: Y
STD PART: Y
PROC INDEX: Y
QAF908: 01 02 06 09 14
DRAWING REV:L
PARTS LIST: N
OPSHEET REV: N/A
S2000: Y

I just need to copy the TYPE, BITS, and BITS_LENGTH data from a single record in the second table to a new record in the first table.

Any work-arounds or suggestions appreciated. Thanks, Steve. Received on Tue Jul 12 2005 - 09:18:00 CDT