Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Pass a Parameter to an Oracle Lite Trigger
Hi,
I have the following java trigger which works great as a procedure
called log delete. The problem is I need to pass
the table name to the procedure. So when I build
the trigger I use:
CREATE TRIGGER TEST_DEL AFTER INSERT ON TEST FOR EACH ROW
LogDelete('TEST',recno);
.
/
But the 'TEST' part gives:
[POL-5228] syntax error
How can I pass a parameter to the procedure like above? Or is there some way in the procedure I can figure out what the calling table is?
Note that the procedure is simple and works flawlessly when called with:
select LogDelete('Test',1) from dual;
BR
Tim
Received on Wed Jan 29 2003 - 15:09:19 CST
![]() |
![]() |