Hi

when i am trying to create the following trigger i am getting PLS-00103

<code>
create or replace
TRIGGER logon_audit
AFTER LOGON ON DATABASE
DECLARE sqlstr VARCHAR2(200) := 'alter session set "_optim_peek_user_binds"=false;';
BEGIN

BEGIN
IF (USER = 'SCOTT') THEN
execute immediate sqlstr;
END IF;

END logon_audit;
<code>


Error(12,16): PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: begin case declare end exception exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe

Not really.

Although the ALTER SESSION statement looks OK, it is not. When used in EXECUTE IMMEDIATE, it shouldn't be terminated with a semi-colon.

Thanks Littlefoot