Flashback to the days of Oracle 7, when this pilot fish is developing a very large package written in Oracle’s new procedural language PL/SQL.

“The package was over 80K of PL/SQL source code,” says fish. “I compiled it on the development server. But while it was compiling, the server perversely chose that very moment to go down!

“My compile ended suddenly with an error message: ‘ORA-03113: end-of-file on communication channel.'”

Fish tells the database admin, who restores the development server. Fish tries compiling the PL/SQL package again, and this time…the same thing happens. Once again the server goes down right in the middle of his compile.

To read this article in full or to leave a comment, please click here

…