SQL Developer and database links through Oracle Gateways

When using a database link that goes through Oracle Gateways to another vendor database (like SQL Server) you might get an error in SQL Developer that says “Bigger type length than Maximum”. Apparently this is a bug in thin JDBC driver. Workaround is to use thick/OCI driver. Select it in preferences and use TNS to … Read moreSQL Developer and database links through Oracle Gateways

Moving between 32-bit and 64-bit server

If you are for some reason moving your database from 32-bit to 64-bit server, a simple copy-paste is not enough. PL/SQL packages are compiled with one word size on 32-bit server and need to be recompiled on 64-bit or the following error might appear: ORA-06553: PLS-801: INTERNAL ERROR [56319]. Metalink note 62290.1 describes in detail … Read moreMoving between 32-bit and 64-bit server