PLS-00907: Can not load library unit

It happens relatively rarely to have an error PLS-00907 (PLS-00907: Can not load library unit). We have encountered it few times in our APEX applications. Here is the way to resolve it (performed by a SYS user). Solution : Ask your DB admin to flush the shared pool 🙂

Oracle MIN() OVER function

Oracle MIN() Over function has an interesting options. It can be used to get the MIN value from a particular subset of data, or show he MIN value, based on the records ranked so far, if it is used with ORDER BY clause. Here is an example: 1 select ename, 2 deptno, 3 sal, 4 … Continue reading Oracle MIN() OVER function →

Oracle 12.1, ORA-01489 result of string concatenation is too long

Listagg is a great way to concatenate strings in Oracle 12. I have used it in many cases, but sometimes it is just not good enough for a very large strings. Here is the way you can use it for strings, that would not exceed 4000 chars: SELECT FNR, ATTEST_DATO, STATUS, TYPE_FORMAAL, LISTAGG(INNHOLD, CHR(13)||CHR(10) ) … Continue reading Oracle 12.1, ORA-01489 result of string concatenation is too long →

Oracle 12.1, ORA-00942: table or view does not exist

This is a bug in Oracle 12.1. When you have a table in one schema (Schema1) with a sequence on some column and you want to insert in that table from another schema (Schema2), error message "ORA-00942: table or view does not exist" is displayed. This happens although you have privileges to select, insert, update … Continue reading Oracle 12.1, ORA-00942: table or view does not exist →