ora-00600: 内部错误代码

pineapple_lch

Yong Huang 发表于 2014-7-3 22:59
create trigger yourusername.logon_set_param
after logon on yourusername.schema
begin

这样的话是不是只能在sys用户下创建？我在非sys用户下创建的时候只能是alter logon on database，不能写成alter logon on sxxnh (sxxnh是当前的用户名)。

Yong Huang

I don't understand. Show me the screen text including the error message.

It's "after", not "alter". ".schema" is part of the syntax.

You can logon as any DBA account, but I don't think it's necessary.

pineapple_lch

Yong Huang 发表于 2014-7-7 22:47
I don't understand. Show me the screen text including the error message.

It's "after", not "alter ...

哦，是after，我回复的时候写错了。下图是我报错的图：

Yong Huang

".schema" is part of the syntax. Please read Oracle SQL Language Reference.

pineapple_lch

Yong Huang 发表于 2014-7-8 22:24
".schema" is part of the syntax. Please read Oracle SQL Language Reference.

我只知道用户名后边跟的是表或视图等对象名称（scott.emp），但是登录触发器这里又不允许表或视图，我真的是不知道在这里要如何写才能是在指定的用户下进行触发。

Yong Huang

Although this thread is one month old, I can't resist to post a reply. pineapple_lch, I don't know why you have trouble with this simple syntax. I said multiple times, ".schema" is part of the syntax here. Why not try it? Please change your sxxnh to sxxnh.schema. "用户名后边跟的是表或视图等对象名称" is completely irrelevant in this context.