Long Raw Trigger Solution ?

[saustin]

Hi,
Have a trigger which references a long raw field type
that does not copy the field BITS (and the 9i help text was clear on this). Does anyone have a work-around or conversion that would work in a trigger they would be willing to share ?

Thanks, Steve.


DECLARE
mTYPE SYSADM.PART_BINARY.TYPE%type;
mBITS SYSADM.PART_BINARY.BITS%type;
mLENGTH SYSADM.PART_BINARY.BITS_LENGTH%type;
BEGIN

SELECT
SYSADM.PART_BINARY.TYPE,
SYSADM.PART_BINARY.BITS,
SYSADM.PART_BINARY.BITS_LENGTH
INTO mTYPE, mBITS, mLENGTH
FROM SYSADM.PART_BINARY
WHERE :NEWDATA.PART_ID IS NOT NULL AND :NEWDATA.PART_ID = SYSADM.PART_BINARY.PART_ID;
INSERT INTO RFQ_LINE_BINARY (RFQ_ID, RFQ_LINE_NO, TYPE, BITS, BITS_LENGTH)
VALUES NEWDATA.RFQ_ID, :NEWDATA.LINE_NO, mTYPE, mBITS, mLENGTH);
END;