ORA-01722 until shared pool is flushed 2006-03-31 - By DENNIS WILLIAMS
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 (See ORA-01772.ora-code.com) 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
<div>Jay,</div>
<div> </div>
<div>I don't see where anyone responded to your posting, so I'll give less than
expert opinion.</div>
<div>So you're getting an "invalid number" error? Review this AskTom
discussion. Apparently this ORA-01772 (See ORA-01772.ora-code.com) can occur in some strange ways. <
/div>
<div><a href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8
_DISPLAYID:45012348053">http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8
_DISPLAYID:45012348053</a><br>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.
</div>
<div> </div>
<div>Dennis Williams<br> </div>
|
|
