Error "IN is not a valid integer" on TOAD
You are using as Oracle 10G release 2 database (10.2.0.2) or higher with TOAD that is less than 8.6.1. When you trying to look or access at the source of a procedure or function or package you may get this error “IN is not a valid integer”.
The solution is either one of below
-- Don’t use oracle database 10.2.0.2 or newer releases. -- Upgrade to TOAD version 8.6.1 or higher. -- Alter the ALL_ARGUMENTS view in your new oracle database under SYS user, moving the SUBPROGRAM_ID column to the end.Note: Altering the data dictionary is unsupported by Oracle, so you probably should not do this to a production database. It does; however, seem to do the trick, with no known side effects.
Copyright - There is no copyright on the code. You can copy, change and distribute it freely. Just mentioning this site should be fair
(C) August 2008, manivelcode
