My objective is to use an Oracle SP in an Informatica Stored Procedure Transformation.
I select the SP Trans. and connect to the database. Listed are two folders "Procedures" and "Functions". Under the Functions folder are functions in that database that I can choose. But, if the function in contained in a Package, it is not available (not listed in that folder) to select from within informatica. Same with SP's.
Hopefully this is a better explanation of the problem.
Thanks and please let me know if I can explain further.