Create Event Trigger fro mSQL Server Function?
Hi!
Still learning my way around BIP 11.1.1.5, and have a requirement to make a report run conditionally. I'd like to create a before report event trigger, and my data resides on SQL Server.
In reality, I'm new to both BIP *and* SQL Server. Our SQL server person told me to just create a function, but it seems like it must reside in a package for BIP to pick it up (according to Oracle documentation).
My questions are:
1. Is it possible to create an event trigger based on objects created on SQL Server?
2. If yes to #1, do I need a package or will the function alone suffice?
Still learning my way around BIP 11.1.1.5, and have a requirement to make a report run conditionally. I'd like to create a before report event trigger, and my data resides on SQL Server.
In reality, I'm new to both BIP *and* SQL Server. Our SQL server person told me to just create a function, but it seems like it must reside in a package for BIP to pick it up (according to Oracle documentation).
My questions are:
1. Is it possible to create an event trigger based on objects created on SQL Server?
2. If yes to #1, do I need a package or will the function alone suffice?
0