Re: After-Insert-Trigger must call external application

From: Dieter Ratsch <dieter.n-o-s-p-a-m.ratsch_at_epost.de>
Date: Wed, 30 Oct 2002 22:29:52 +0100
Message-ID: <appiub$77l$03$1@news.t-online.com>

Sybrand Bakker wrote:
> I would consider starting up php on after-insert an extremely bad idea
> and a sign of an application hold together by ropes and sellotape.
> Brrr... Are you really sure you *have* to use php and you can't do it
> in ordinary pl/sql. I would strongly advise you to reconsider.
>
> That said: yes it can be done. Oracle comes with an external procedure
> facility (which you can look up in the doco) and for which the
> listener has to be configured. Just be aware, obviously, those
> external procedures run *on the server*, *NOT* on the client.
> Hth
> Sybrand Bakker, Senior Oracle DBA

This could help! Of course - it's 'quick and dirty', doing it in this way, but i don't know a solution for my problem with PL/SQL or other Oracle-Tools:
PHP reads out the BLOB's in the inserted (and some other) records, which contains uploaded i.e. Word-, Excel- and Powerpoint-Docs, text-fields and other informations and generates in a very complex way 1 PDF-Document for a catalog. This is already done and the results are nearly perfect!
I will use PL/SQL as soon MS-Office can generate XML-output in a usable quality and not in MS-XML(!) and hope, this feature is available soon!!!

Sure - the external procedure must run on the server, that's what I'm looking for!

Regards (excuse my bad english - I'm still learning...) Dieter Ratsch Received on Wed Oct 30 2002 - 15:29:52 CST