Category: PL/SQL

In my previous post I mentioned the problem with compiling a program unit that calls a database function with result cache. Like I wrote in that post, the problem exists in the PL/SQL Client version. There’s a patch available to update the PL/SQL client: Oracle Database Server Version Patch 33. This is a database […]

When you try to convert an xml file, which has a tag that contains for example one or more pdf files, into an XMLTYPE object, you will get the following error: ORA-19011: CHARACTER string BUFFER too small This error will be thrown because the content of a tag of an XMLTYPE is limited to 4000 […]

If you’re developing a Java Application which integrates with an Oracle back-end, you’ve probably run into the following technicalities:transforming an arraylist as a parameter to a callable statement to process and persist the data in your Oracle Database. How can you accomplish this in a generic and re-usable manner:1. Create an objecttype (PL/SQL) – Backend: […]