Re: After-Insert-Trigger must call external application

http://asktom.oracle.com/pls/ask/f?p=4950:8:1529329::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:952229840241,%7Bjava%7D%20and%20%7Bunix%7D

that is an article at asktom.oracle.com in which you setup a java stored procedure to run external commands. I am currently using it for a few fun things and it works very well. All of the source is there all You need to make sure of is that you have the JVM installed on your oracle database.

Adam

Dieter Ratsch <dieter.n-o-s-p-a-m.ratsch_at_epost.de> wrote in message news:<appiub$77l$03$1_at_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 Thu Oct 31 2002 - 12:43:38 CST