Is it possible to connect to an oracle database from a trigger in
ASA9? I can also use newer versions of ASA if needed.

Jan Erik,

you can use Proxy Tables (aka "Remote data access") to connect to
different databases (both on different servers/DBMS and on the same ASA
server).
Once you have created a proxy table to your orcacle database, it sould
be possible to access that table from within triggers.
However, take care with commits as any trigger runs inside a
transaction, and I'm not sure whether it's possible to update data in
proxy tables within a SA transaction.

Have a look at the docs. In SA 10, it's in the "SQL Anywhere® Server -
SQL Usage" manual.

HTH
Volker

Jan Erik wrote: