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;
Printable View
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