has anyone every connected a script to a database in IPCC using a stored procedure to call a package instead of a hard coded SQL query. We have millions of records in the database on multiple tables and cannot use a hard coded SQL query. Natively would be the best but I am almost sure that is not supported. Anyone who has any info please let me know.
I am using IPCC Express Premium, and am querying the database through an OBDC driver. The problem is a hard coded query is not efficent on such a large database. I need to somehow pass the query on to a package in the database and alow oricle to do the query and pass the results back to the IPCC. I don't like the OBDC I would rather have Native but I can deal with the OBDC. I definitly can not have a hard coded SQL query repeatedly hitting the database.
These are the paths to get to each CCX logs through CLI. They may be helpful if you are having issues accessing RTMT or downloading logs through it.
If you want to download them you have to prefix "file get " and you can add one of the options (re...