Home » RDBMS Server » Enterprise Manager » problem in trigger
problem in trigger [message #151762] Mon, 19 December 2005 02:09 Go to next message
kinjal
Messages: 124
Registered: June 2001
Senior Member
Hello all,

I have created one trigger to track ddl changes for particular schema.

I have attached the code for the trgger.

Now the problem is, it is simultaneously inserting some data like,

ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN'
ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'A
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YY'
.
.
.

These kind of statements are automatically inserted in the table.

Why is it happening I am not able to understand.

What can be the cause? Is there any parameter set or something like that?

Please help me.

Kinjal
Re: problem in trigger [message #151842 is a reply to message #151762] Mon, 19 December 2005 07:08 Go to previous message
orausern
Messages: 826
Registered: December 2005
Senior Member
Hi,

You can start debugging this by finding WHEN these records are getting inserted? for eg. do they get inserted when the user logs on to the db?
for this you can add a database field to the table ddl_log like
time_stame and in the insert statement add time_stamp and then check when this insert is happening?

Most probably they would be when the user tries to log in ..but can u check out?

I am assuming that ddl_log is a table that you have created and you or your dbas are fine with adding a column to that table..if not then DO NOT use this suggestion!

N.
Previous Topic: OMS question
Next Topic: Role and privileges
Goto Forum:
  


Current Time: Wed Dec 08 16:43:57 CST 2021