resumable trigger not valid :-(

Hi all,

what is wrong on this statement?

Do you have an idea? Thank you!!! Christian

CREATE OR REPLACE TRIGGER ck.logon_ck
AFTER SUSPEND
ON DATABASE
declare
BEGIN
alter session enable resumable timeout 3000 name 'Krischan';
END;

Maybe ...

Code:

---

CREATE OR REPLACE TRIGGER ck.logon_ck
AFTER SUSPEND
ON DATABASE
declare
BEGIN
execute immediate 'alter session enable resumable timeout 3000 name ''Krischan''';
END;
/

---

Oh sorry! You are right!

Thank you very much.

Christian