| problem in trigger [message #151762] |
Mon, 19 December 2005 02:09  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
