Creating PDF's with PL/SQL and itext

By | 2009-06-20T22:30:23+00:00 June 20th, 2009|Categories: Database|Tags: , , |

There are several ways to create PDF's, on the client (e.g. PDFCreator) or on the middletier. But to create PDF's merely with packages in the database, that's another story. Even Apex uses some Java on the middletier. The product PLPDF on the other hand is a well known utility which provides this functionality (using open-source 'itext'), but.. you have to pay for this. So why not do it ourselves with itext, open-source (answer: a lot of work and knowledge of Java...).

Create virtual host with Webcache on OAS

By | 2009-06-12T09:10:42+00:00 June 12th, 2009|Categories: App. Server|Tags: |

Creating Virtual Host with Webcache and HTTP-server. Not that high-tech, but takes quite a lot of small steps, and must be done without taking risks in a production environment. I did this with Enterprise Manager, while I did not completely rely on my abilities on updating the $ORACLE_HOME/webcache/webcache.xml ..... , and eventually I had to hand it over to the production-DBA.

Updating sequences, the Developer's way

By | 2009-06-08T10:15:50+00:00 June 8th, 2009|Categories: Database|

As a DBA it’s quite common to update sequences by altering the increment of the sequence temporarily. Therefore it’s nice to know how Developers are  acting with the problem that a sequence is not in line with the corresponding id of a table. Just another view on this matter, kind […]

Discoverer, can't edit some workbooks, OLException

By | 2009-06-08T10:06:17+00:00 June 8th, 2009|Categories: App. Server|

A Discoverer item:  while trying to edit some workbook items or when choosing Edit -> Condition , errors popped up like this:
“OracleBI Discoverer   :    java.lang.ArrayIndexOutOfBoundsException ”

“An error occurred while attempting to perform the operation.
The operation did not complete successfully.

Extra Internal Info:
Cause:OLException {
Code: OLCmRefException::eNullRef
Args: OLCmRefException::eNullRef}}

Version Discoverer:

Doc ID:     559541.1:
After applying […]