Re: ORA-00997 8i trigger long raw problem

From: Steve <saustin_at_hsius.com>
Date: 14 Jul 2005 11:32:30 -0700
Message-ID: <1121365950.533396.40540@f14g2000cwb.googlegroups.com>

Hi Jim,

           Many thanks for your post. Was able to get further. Created a table RFQ_LINE_TEMP similar to a production table RFQ_LINE_BINARY that is now populated with the long raw data after the trigger fires.

           For some crazy reason the BITS, and BITS_LENGTH fields in the RFQ_LINE_BINARY table do not populate. Have checked constraints but do not see anything obvious.

DECLARE

   v_error            number;
   v_bits             varchar2(4000);
   v_newbits          long raw;
   V_USERNAME         VARCHAR2(50);
   V_MACHINE          VARCHAR2(30);
   V_PROGRAM          VARCHAR2(64);
   v_RFQ_ID           VARCHAR2(15);
   v_LINE_NO          number;
   v_PART_ID          VARCHAR2(30);
   my_var             long raw;
   v_BITS_LENGTH      number;
   v_TYPE             CHAR(1);

PRAGMA AUTONOMOUS_TRANSACTION; CURSOR GET_RFQ IS
SELECT
   :NEWDATA.RFQ_ID,
:NEWDATA.LINE_NO,
:NEWDATA.PART_ID,

     p.BITS,
   p.BITS_LENGTH,
   p.TYPE
FROM SYSADM.PART_BINARY p
WHERE :NEWDATA.PART_ID = p.PART_ID;

BEGIN OPEN GET_RFQ;
 FETCH GET_RFQ INTO

      v_RFQ_ID,
      v_LINE_NO,
      v_PART_ID ,
      my_var,
      v_BITS_LENGTH,
      V_TYPE;

INSERT INTO RFQ_LINE_BINARY (RFQ_ID, RFQ_LINE_NO, TYPE, BITS, BITS_LENGTH)
VALUES(v_RFQ_ID, v_LINE_NO, v_TYPE, my_var, v_BITS_LENGTH);

INSERT INTO RFQ_LINE_TEMP (RFQ_ID, LINE_NO, PART_ID, BITS, BITS_LENGTH, TYPE)
VALUES(v_RFQ_ID, v_LINE_NO, v_PART_ID, my_var, v_BITS_LENGTH, v_TYPE);

CLOSE GET_RFQ;
COMMIT;
END; Received on Thu Jul 14 2005 - 13:32:30 CDT