How to draw the line that triggered the trigger pl/sql?

Viewed 86

This is my code:

CREATE  OR REPLACE  TRIGGER TR_DEL
AFTER INSERT OR UPDATE
ON DIZIONARIO_CHIAVI_DA_ESCLUDERE
FOR EACH ROW 
DECLARE
    CURSOR c_cursore_prendi_riga IS 
       SELECT CURRICULUM_CHIAVE_RICERCA 
         FROM PERSONA; 
    myCursor PERSONA.CURRICULUM_CHIAVE_RICERCA%TYPE; 
BEGIN
  OPEN c_cursore_prendi_riga;
  LOOP
    FETCH c_cursore_prendi_riga INTO myCursor;
    EXIT WHEN c_cursore_prendi_riga%NOTFOUND;
    dbms_output.put_line('oo='|| myCursor );

    -- Here I need it      

  END LOOP;
  CLOSE c_cursore_prendi_riga;
END;

I need the row that started the trigger, thanks

1 Answers
Related