Re: trigger

devis skrev i meddelelsen <3505512D.60A0_at_mall.it>...
>I have a question:
>
>Is it possible to execute external SQL Plus commands like EXP (export)
>from within a trigger? If so how can I code this? If not then is there
>another way to perform this function.
>
>Basically, I want to export tables in format ascii whenever an INSERT
>statement is executed using a Trigger.
>
>Thanks in Advance.
>--
>Devis Pizzolon
>Database Master
>Mall Italy Lab.
>http://www.mall.it
>devis_at_mall.it

Hi,

I don't know what version of Oracle that You're running, but You could program your export in a procedure, and then call the procedure from the trigger.

Gitte Tøgersen
Denmark
email: danskdata_at_hotmail.dk Received on Wed Mar 11 1998 - 00:00:00 CST