Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Pass a Parameter to an Oracle Lite Trigger

Pass a Parameter to an Oracle Lite Trigger

From: TimMcConechy <tjm_at_runtime.dk>
Date: 29 Jan 2003 13:09:19 -0800
Message-ID: <7afae186.0301291309.3d540779@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US