I am not able to select my package from the dropdown in Event Studio and add a 'Update a database' trying call a stored procedure from the package. I don't see my package in the dropdown.
These are the steps I have already done.
- Added Stored Proc to Framework Manager as Data Modification
- Tested and Validated Procedure in FM
- Published Package
- Create New Event
- Select package with Procedure in it
- Attempt to add 'Update a database'
Has anyone run into this issue before? Is there a configuration setting to allow the package with the procedure to be made available in the Event Studio Dropdown? Permissions? I have tried this in 2 different environments with no luck.
All suggestions are appreciated.
~M
Environment - Oracle 10~ish, Cognos 8
After going through previous posts more thoroughly I found reference to an issue similar to mine. I needed to publish the package in the root directory of Public Folders and not in a folder (which mine was).
Procedure was made available and worked fine.
http://www.cognoise.com/community/index.php/topic,6878.0.html (http://www.cognoise.com/community/index.php/topic,6878.0.html)
~M