This discussion is archived
0 Replies Latest reply: Feb 11, 2009 12:58 PM by 600287 RSS

pl/sql callbacks

600287 Newbie
Currently Being Moderated
Has anyone ever had the plsql callback testproc work for them???

I'm on 10.1.3.0.1.

I run
exec edg_utl.add_rule(rulename => 'MyRule', condition => ':event.type = 200', param => 'edg_utl.testProc',command => 'call')

I added an insert in the testProc to insert into my testtable. That way I don't have to worry about the log level stuff.
I never, ever, get any rows to insert into that testtable. That leads me to believe that the testProc never gets called.

I even restart the whole machine. Nothin'.

I've read the README in j2ee\home\applications\edge\edge\sample\StreamsSample
I've ran:
exec DBMS_APPLY_ADM.STOP_APPLY('EDG_APPLY');
exec DBMS_APPLY_ADM.START_APPLY('EDG_APPLY');

So, again, if you have successfully made this work, please do let me know some other actions I can try.
Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points