Get trigger value

[Bene]

Hi. I have a problem.
How do I get the values ??of the last line I'm inserting to play for another table?
I'm trying to make a trigger more is failing.

How do I make a trigger send the last line entered to a log table?

Thanks

Rafael R. Machado

[Trevisolli]

Brother,

In your trigger, throw the value of : New.Campo on a log table.
Would this be?

[Bene]

Good morning, my friend

So, that's exactly what I want to do just can not do.
is very simple, but I'm picking up here.

I created a test table, and in it I will play the email address that I am inserting into another test table.
Please, what's wrong here?

The email table is thus
userid, mailaddr

in the trigger I am doing in this table I am doing this:

Select all

 
CREATE OR REPLACE 
TRIGGER TRIGGER1 
 AFTER INSERT ON MAIL 
 REFERENCING OLD AS old NEW AS new  
BEGIN 
  insert into TABEL1 (COLUMN1,COLUMN2) values (:new.USERID, (select sequence1.nextval from dual)); 
END; 

But it always results in this error here:

Select all

Error: ORA-04082: NEW or OLD references not allowed in table level triggers

What is wrong here?

Thanks for the help, man, always you respond to my posts Uhaua

[Trevisolli]

Brother, follow some examples:

Select all

 
 
CREATE TABLE teste (id number(05), email varchar2(50)); 
 
CREATE TABLE teste2 (email VARCHAR2(50)); 
 
CREATE OR REPLACE TRIGGER TESTE_TR_01 
 AFTER  
 INSERT 
 ON TESTE 
 REFERENCING OLD AS OLD NEW AS NEW 
 FOR EACH ROW  
BEGIN 
 INSERT INTO TESTE2(EMAIL) 
  VALUES(:NEW.EMAIL); 
END; 
 
INSERT INTO TESTE (id, email) VALUES (1,'paulotrevisolli@ig.com.br'); 
 
COMMIT; 
 
SELECT * FROM teste; 
 
SELECT * FROM teste2; 

If it does not work, send us to us.

[Bene]

We're almost expensive.

only has a problem, I have a sequence that has to control the log table IDs.
How do I declare a variable that can have the value of this sequence?
Example:

Select all

CREATE OR REPLACE 
TRIGGER TRIGGER1 
 AFTER INSERT ON MAIL 
 REFERENCING OLD AS old NEW AS new  
 for each row 
DECLARE 
  IDEvent int; 
BEGIN 
   IDEvent :=  select sequence1.nextval from dual; 
 
  insert into TABLE1 (COLUMN1,COLUMN2); 
  values (IDEvent,:new.USERID); 
END;

This code here in error.
How do I declare variables in Oracle?

Thanks for the man help.

Rafael R. Machado
Sorocaba

[Bene]

I got people here.

Thanks for aid there

Rafal R. Machado

[Trevisolli]

Brother,

Here is an example, for those who may need:

Select all

 
    DECLARE  
      vseq PLS_INTEGER; 
    BEGIN 
      SELECT TUASEQUENCE.NEXTVAL 
        INTO vseq 
       FROM dual; 
    EXCEPTION 
      WHEN OTHERS THEN 
        -- Trata tuas exceções aqui...     
    END;   

[bvinicius]

Good evening,

I looked for some open topic about it and what I found closer was this.

Work as a programmer and use SQL bank and now in college I am using Banco Oracle and picking up a lot rsrs.

My difficulty is in the following:

I need to record in a field the description plus the sequential cod that Sequence generates through NEXTVAL, I tried several ways :

Assigning to a variange, eg

Select all

v_num := s_saida.nextval

Concatenating directly in the INSERT EX:

Select all

'descricao ' + to_char(s_saida.nextval)

and through a SELECT also .

But the following error is returned:

The reference S_SAIDA.NETNETVAL to the table, view or sequence not allowed in this context.

Someone could tell me, what is the correct way to manipulate the next to the next and concatene it with some more information?

Thank you in advance.

[Renato Menezes Viana]

See the link below:
http://www.oracle.com/technetwork/pt/ar ... 1-ptb.html