| why report triggers runs twice? [message #90191] |
Wed, 01 December 2004 22:47 |
jag
Messages: 15
Registered: July 2002
|
Junior Member |
|
|
Hi All
i am working in report6i tool conencted to oracle9i database.
The sequence in which the trigers normally executes is
1)Before Parameterform
2)After Parameterform
3)Before Report
4)Between Pages
5)After Report
but i noticed that when i execute my report the BEFORE PARAMETERFORM and AFTER PARAMETERFORM is being triggered twice which is making performance issue...
1)Is there anyway to restrict thoose two triggers to run only once?
2)also i would like to know the purpose behind that concept of running the triggers twice??
i found this happening with the help of placing srw.message inbuilt package in all the triggers.
rgds,
jagdish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
