| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-01722 until shared pool is flushed
Jay,
I don't see where anyone responded to your posting, so I'll give less than
expert opinion.
So you're getting an "invalid number" error? Review this AskTom discussion.
Apparently this ORA-01772 can occur in some strange ways.
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:45012348053
Since you say that flushing the shared pool seems to alleviate the problem
for awhile, this problem might somehow be related to the shared pool getting
fragmented. You might consider pinning this stored procedure in memory.
Dennis Williams
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 31 2006 - 10:33:01 CST
 |
 |