Re: ORA-01722: Invalid number

Liam McCauley (Liam.McCauley_at_Syntegra.BT.CO.UK) wrote:
: Oracle 7.3.2.2
: Sun Solaris 2.5.1
 

: Yesterday, several users received ORA-01722 errors in an Oracle Report
: (2.5) and a database procedure. These errors were reproducable at will.
: The database was shutdown last night, and today the problems have
: disappeared.

Yep seen it multiple times on HPUX with 7.3.2, it has to do with the shared pool going nuts. do a alter system flush shared_pool and all will be well, is it a documented bug, i believe so, but i dont know what the number is, also, this will cause all SQL in the SGA to go away, so the first time each of the new sql hits there, it will need to be parsed, just a FYI, joe

-- 
Joseph S. Testa, Database Administrator, Ohio EPA
  Founder of #oracle-dba on IRC, dal.net,  to find a server go to www.dal.net
  http://web.scioto.net/jtesta   <--- Find scripts on how to create a second
  instance :)