Ouch! We got a wonderful ORA-03113 running a PL/SQL procedure last week. Just two seconds after executing the routine via SQL-Plus the session was terminated with an ORA-03113 end-of-file on communications channel. This happend both on a linux box and an AIX system both running Oracle 9.2.0.6.
Infact the procedure was crashing with a memory access vialotion. This could be seen after taking a look in the oracle alertlog.
Oracle support was able to analyse the problem and match it to a known bug 3256015 and suggest installing an available patch 3256015 - which we did... and hey presto the procedure works fine now.
July 2005 Archives
Hunting for some online documention on alter database and co. I stumbled across a site http://www.ss64.com which had an article on the subject. Refering the problems with views it stated:
"You know, the very powerful and the very stupid have one thing in common, they don't alter their views to fit the facts, they alter the facts to fit the views, which can be uncomfortable, if you happen to be one of the facts that needs altering."- Doctor Who
