support for trigger and stored procedure

[alauddinctgbd]

hi everyone,

 

How can i fire a trigger(which run the stred procedure) for oracle before running the report by using jasperintelligence or iReport or jasperreport jrxml tags.

 

Any help appriciated

 

Alauddin

[teodord]

Hi,

 

If your trigger calls a stored procedure, why can't you call that stored procedure directly and want to call the trigger??

 

Anyway, you cannot call triggers. Triggers are something that only the database server can trigger (hence their name) when specific operations occur: update, delete or insert into a table.

 

Now if we go back to stored procedures and Oracle, here are some resources that might help you:

 

http://jasperforge.org/sf/projects/oraclestoredprocedures

 

http://www.brianburridge.com/2006/06/04/how-to-call-stored-procedures-from-jasper-reports/

 

I hope this helps.

Teodor