Error "IN is not a valid integer" on TOAD

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