plsql - Encountered the symbol "." when expecting one of the following: ; -

sql> create or replace  2  trigger c##iam_admin.after_logon_trg after logon on c##iam_admin.schema  3  begin dbms_application_info.set_module(user, 'initialized');  4  execute immediate 'alter session set current_schema=c##iam';  5  end c##iam_admin.after_logon_trg;  6  /  warning: trigger created compilation errors. 

when check show errors gives

errors trigger c##iam_admin.after_logon_trg: 

pls-00103: encountered symbol "." when expecting 1 of following:

untested, closing tag should label , not qualified name. try:

create or replace trigger c##iam_admin.after_logon_trg     after logon on c##iam_admin.schema begin     dbms_application_info.set_module(user, 'initialized');     execute immediate 'alter session set current_schema=c##iam'; end after_logon_trg; 

i'm not able test right , i'm not sure can use end tag there, if doesn't work, try ending just

end;