Re: The pseudo-records :NEW.

From: Oscar Martinez <oscarm_at_sicon.net>
Date: Wed, 15 Sep 1999 09:49:48 +0200
Message-ID: <7rnj16$s9v$1@talia.mad.ttd.net>

Sorry, for the wrong question. I'm working in a Oracle Database v8.0 and WinNt WorkStation ver 4.0.

I use the pseudo-record in this way:

In this trigger, I only make this:

CREATE OR REPLACE TRIGGER GENERAR_FACTURAS AFTER INSERT ON INSERCION
FOR EACH ROW DECLARE

   ID_ORDE VARCHAR2(10);
   ID_INSER VARCHAR2(10);
   ID_CLI VARCHAR2(10);
   FL_FACT CHAR(1);

C_ESPECIAL VARCHAR2(10); BEGIN

    ID_CLI:=:NEW.ID_CLIENTE;
    ID_ORDE:=:NEW.ID_ORDEN;
    ID_INSER:=:NEW.ID_INSERCION;

C_ESPECIAL:=:NEW.ID_COND_ESPE;
FL_FACT:=:NEW.FLAG_FACT;
END; Only make this, happend the error describe in the original message:

ORACLE error: unable to INSERT record.

Thanks for your help, Sybrand. Received on Wed Sep 15 1999 - 02:49:48 CDT