"Steve" <saustin_at_hsius.com> wrote in message
news:1121177880.645342.54800_at_o13g2000cwo.googlegroups.com...
> 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.
>
- Long Raw is deprecated (so is long) Use LOBS.
- Store character data in character fields not binary fields. (same for
binary data, number data, text data)
Convert to a clob.
Jim
Received on Tue Jul 12 2005 - 09:41:27 CDT
