Re: Can I do some low level program in oracle database?

You can do this with a trigger link:
1) create the database link

CREATE public database link TRIGGER_LINK USING 'remote';

Oracle tries to connect to the other DB with the current user/passwd It also needs to setup a TNS entry for remote.

2) create the trigger

CREATE trigger SEND_DATA
AFTER INSERT OR UPDATE ON MY_TABLE
FOR EACH ROW
BEGIN

	insert into MY_TABLE_at_TRIGGER_LINK
	VALUES ( ...... )

END; This way is only usable if your volume isn't so high. Otherwise use snapshots!

Henning

On Thu, 27 Sep 2001 16:44:35 +0800, zhao hongbin <m996224_at_wkg1.umac.mo> wrote:
> Hi:
> I want to do some low level program in oracle database,for example
> when the record value in the database is modified,then trigger my
> program that can send the modified data information to the other site.
> although i try to look for the possibility,till now I haven't find the
> result.Could you tell me?
> thanks
> marshal
>
>

-- 
Henning Follmann      |     8 Jane Road
Tel.: +1 908 656 7061 |     New Providence, NJ 07974
H.Follmann_at_gmx.de     |     USA


-----=  Posted via Newsfeeds.Com, Uncensored Usenet News  =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
 Check out our new Unlimited Server. No Download or Time Limits!
-----==  Over 80,000 Newsgroups - 19 Different Servers!  ==-----