home go links go books go opinion go gallery go projects go resumé go
about this site
archives
book reviews
"to read" list
tech books
search books
books archive
last 10 posts
quotes
cluetrain
cluetrain (mirrored)
randobracket
image auth
search engine hits
  hit history
indexer stats
user agent list
HTML (view)
  (most up-to-date)
MS Word (dl)
code examples
doesntsuck.com
doesntsuck.com

February 12, 2004

oracle RPC bug   (link)

http://www.jusungyang.com/ORACLEfolder/plsql/Interesting/PackageState.txt

SQL> -- RPC problem with ORA-4068
SQL> -- When a remote procedure is recreated after it has been executed from another db,
SQL> -- the first subsequent call to the procedure from this db will fail.
SQL> -- I consider this to be a bug.
SQL>
SQL> -- Error can be avoided by flushing the shared_pool of the calling db,
SQL> -- or by slightly changing the text of calling the procedure
SQL> -- this will create a new entry in the shared pool
SQL> -- or simply by calling the procedure a 2nd time.

Posted by yargevad at February 12, 2004 09:58 AM


This weblog is licensed under a Creative Commons License.