Category Archives: Databases

CAS Registry Number Validation using PL SQL

CAS Registry Numbers are universally used to provide a unique, unmistakable identifier for chemical substances. CAS stands for Chemical Abstracts Service, a division of the American Chemical Society, that assigns a unique numerical identifier to every chemical substance described in the … Continue reading

Posted in Oracle, PL SQL | Leave a comment

ORA-03113: end-of-file on communication channel

One of the lesser used features in an application using Oracle Database installed on a UNIX server stopped working recently throwing the ORA-03113 error. The oerr utility provided the following information: $ oerr ora 3113 ORA-03113: end-of-file on communication channel … Continue reading

Posted in Databases, Oracle | Tagged , | 2 Comments