After parameter form trigger in report builder executes twice

Dear All,
Actually what i do is that i call a DB proc in after parameter form trigger to prepare data in a table. but as this trigger fires twice so the proc s called twice and it take double time
Any solution plz so that i can execute the proc just once.

Dilshad
dilshad_chAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

schwertnerCommented:
Try to fire the trigger in BEFORE REPORT trigger.
0
DanielztCommented:
So you need to figure out what events fire your trigger. make sue only one of them working is enough.
0
dilshad_chAuthor Commented:
Thanx for comments but this does not solve my prob.
i cant prepare data in before parameter fprm trigger.
Plz tell is this default behaviour of report builder that it calls after parameter form trigger twice?
or is this a bug of RB?
and how to control it?
Thanx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

schwertnerCommented:
It is not usual to execute this trigger twice. Download from OTN the last version of Reports with the latest patchset and try it.

By the way I mean BEFORE REPORT TRIGGER. It is after Parameter Form trigger. If I do not use the right name
0
dilshad_chAuthor Commented:
refference to my last comments
read as
i cant prepare data in before report trigger
0
joekendallCommented:
You could create a global variable or a parameter and set it in the After Parameter Form trigger. In the After Parameter Form trigger, you will check its value and decide to run the proc based on that value.

If variable/parameter = 1 Then
    Run Proc;
    variable/parameter = 0
End If;

Joe
0
dilshad_chAuthor Commented:
Thanx Joe for sparing time,
1-global variables odes not work in report builder
2-We cant use parameter as it initializes the parameter again when called 2nd time so as the case with variables.
so your provided code will not work we have already tested it

Dilshad
0
schwertnerCommented:
Try to reinstall Reports and download the latest version of Reports. Again - it is the normal functionality of Reports.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.