David Pylatuk wrote:
Is this possible in 8 or 9 ?
Does anyone have an example ?
Thanks
Calling out from the database is possible (both versions) - it's called
EXTPROC or External Procedure. Check the Oracle documentation and OTN's
Oracle By Example for examples and details (or take Oracle's Advanced
PL/SQL course <g>)
Generally requires a PL/SQL 'call-out' and appropriate Oracle Networking
setup.
Have to admit, I've never attempted it from a trigger. Between Oracle's
UTL_TCP, UTL_SMTP, UTL_FILE, I've rarely had to use call-outs though.
/Hans