Forum OpenACS Q&A: Re: Problem Installing The Jabber Package

Posted by Tom Ayles on
Hi Bjoern,

I've downloaded your new version, and it works fine - thx! Regarding the pl/sql problem, whilst PostgreSQL requires that the functions are called using a SELECT statement, Oracle won't allow you to invoke a function that performs DML from within a SELECT (ORA-14551), which pretty much leaves us between a rock and a hard place as far as a simple solution to dual database compatibility is concerned.

Anyway, I've decided to go ahead with using the various components of the package for a project I'm working on, and will probably be doing quite a bit of work with it. For now, my priority is to get the exact functionality I need up and running on Oracle, later on I'll figure out how best to deal with the PostgreSQL issue. I might end up just having a version of nsjabber for each DB, but I'd prefer to end up with a single set of code that once compiled would run on either.

Thanks again for making this update available,