Problem With a Data Base Trigger Creation [message #39928] |
Sat, 24 August 2002 08:45 |
Robinson
Messages: 5 Registered: August 2002
|
Junior Member |
|
|
Look, i've the next commands in a Data Base triger:
DECLARE
CURSOR AUD IS
Select column_name columna from user_tab_columns
Where table_name ='ZONA';
campo varchar2(30);
campo1 varchar2(30);
cadena varchar2(400);
Begin
For a in aud loop
campo:=a.columna;
campo1:=':new.'||campo;
cadena := cadena ||campo||': '||campo1 ||', ';
End loop;
Insert into borrar(cad) values (cadena);
END LOGO1;
What i wish is insert in a table all the news value fields to audit when i insert a row, but i got the problem with ':new.'||campo because i need that the PL/SQL don`t take it as a character string, i need insert is the :new.codzon value not the ':new.codzon'
string.
Help me please !! does anyone give me a idea ?
|
|
|
|