I have a pl?sql package that was in our 8i database. I had the DBA's move it to our 10G db. When I go to view it in toad as soon as I click on the package it gives me an error message 'IN' is not a valid integer value.
This opens fine in 8i. Is it a problem with the versions? this package is used to purge jobs in our PeopleSoft environment, and I am moving it into another environment. I have attached the PL/SQL spec and body. Gandolf989 was helping me earlier with this package but that was when it was in 8i.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.