Re: Oracle Triggers and File Access

Hi

I have successfully written to OS files from a database trigger before. I was asked to create SQL statements for inserts, updates and deletes on certain tables during a data migration when those tables changed. The system used a legacy application generated in a tool and the developers thought seeing the actual SQL generated and in what order it was applied would help them debug it.

anyway it can be done and the write to a file doesnt roll back, but that can also be solved with a log table and autonomous transactions.

hope this helps

kind regards

Pete

-- 
Pete Finnigan

Email : pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com

Pete is the founder of PeteFinnigan.com Limited a UK based company specialising 
in Oracle security audits and services. Email info_at_petefinnigan.com for details 
and availability.

Pete Finnigan is the  author of the recently published book about Oracle 
security from the SANS  Institute "Oracle security Step-by-step (A survival 
guide for Oracle security)" - see http://store.sans.org for details.

Some recently published articles include:

http://online.securityfocus.com/infocus/1689 - "Introduction to simple Oracle
auditing"

http://online.securityfocus.com/infocus/1644 - "SQL injection and Oracle - part 
one"

http://online.securityfocus.com/infocus/1646 - "SQL injection and Oracle - part 
two"