We recently created a new database and have a couple ADF applications using this new database(12C). I'm running into an issue where i modified a function within a package that returns a table (custom type in the package spec). If i run the function straight from sql plus i get the new correct table, but when i have this running from an ADF application its getting the old functions table. When testing against our older 11G database i get back the updated table from the function within our ADF application. So it works on our older 11G database but not our new 12C database.
I'm wondering if we have a property/parameter set on our older database that we overlooked and did not get set on the new 12C database. Does the database cache package functions for sessions? I know packages can have states is this something that may be causing my issue? Any help or pointers is appreciated.