ORA-06533: Subscript beyond count

yup. This error happend after the migration from 11g to 12c. What’s going on. Having this type defined: CREATE OR REPLACE TYPE jka_nt_varchar2_100 AS TABLE OF VARCHAR2(100). In 11g it was no problem when the variable based on this type was nog properly initialized: declare l_values jka_nt_varchar2_100 := jka_nt_varchar2_100(); begin l_values(1):=’abcd’; end; Only in 12c […]

Correcting wrong aspect ratio….

Another video thing. I’ve started to digitize some old VHS tapes with family stuff on it. Took my old VHS machine from the attic, blew of some dust and connected it with my Panasonic dmr-eh68 Hardisk recorder with a svhs cable. I put the Harddisk recorder in XP mode (highest quality) and started recording tapes […]

Dropbox alternative

With my high speed ziggo connection (200 mbit down and 20 mbit up) it’s very attractive to not spend dollars in Dropbox. So I created our own cloud. Tool: Owncloud Setup is very easy. I’ve installed some server. This server can be as tiny as an raspberry pi, it can be some synology. But I build […]

nieuw uitprobeer projectje

slim framework entomb json (weet alleen niet waarom ik die gebruik, is te veel overhead) fullcalendar (moet heel veel hannesen om entomb json overhead uit te poetsen) jquery bootstrap (en linux/apache/php/mysql)

view showing full table hierarchy (level) in current schema.

CREATE OR REPLACE FORCE VIEW PLD.PLD_TABLE_HIERARCHY_VW ( TABLE_NAME, HIERARCHY_LEVEL ) AS WITH t AS ( SELECT p.table_name table_name, LEVEL hierarchy_level FROM all_constraints p LEFT OUTER JOIN all_constraints r ON r.r_constraint_name = p.constraint_name AND r.owner = p.owner WHERE p.owner = SYS_CONTEXT (‘USERENV’, ‘CURRENT_SCHEMA’) AND ( (p.constraint_type = ‘P’ AND LEVEL = 1) OR (p.constraint_type = ‘R’ […]