Trigger fails to trigger

[dbasan]

When ever a local table is either INSERTed or UPDATEed trigger has to fire by INSERTing the record in the remote table.

Local table: Oracle 9i on windows
Remote table: SQL server 2000 on windows

1. DBlink is working fine
2. ODBC connection is good too

On INSERT or UPDATE the trigger is not firing and not throwing any error. Checked the possibilities. Where to start to troubleshoot?

[KenEwald]

I'd bet your trigger is firing, just not doing what you think it should do.

Have you tried putting some debugging code in your trigger to insert variables, "Im in here", etc. into a local table?

[sambavan]

Put some dbms_output in your trigger and see whether it gets fired

[davey23uk]

dbms_output wont help as it executeed by the server, nowhere for your output to be sent

[dbtoo]

is the trigger and dblink owned by the same schema?

[dbasan]

dbms_output wont help as it executeed by the server, nowhere for your output to be sent

The same i was wondering as how to execute

is the trigger and dblink owned by the same schema?

yes

[dbasan]

As i mentioned earlier abt the different RDBMS could the incompatibility between column sizes between the tables givin all troubles.

[davey23uk]

you will need to debug it, use insert statements or utl file to trap what is going on

[KenEwald]

you will need to debug it, use insert statements or utl file to trap what is going on

That's what I was trying to say in my first post. Create a table, then insert your variables, errors, etc into a varchar column in that table. If there's no rows in it, it's not firing, if you get rows, they'll tell you what's going on.

utl_file is another good option. Davey's got it goin' on.