SQL & PL/SQL

Hi,

got a strange problem here.

The following script execute perfectly
CREATE OR REPLACE TRIGGER VersionInsertTrigger
BEFORE INSERT ON Version
FOR EACH ROW
BEGIN
SELECT VersionSequence.nextval INTO :new.Idx FROM dual;
SELECT UID INTO :new.UserIdent FROM dual;
SELECT UPPER(:new.Entity) INTO :new.Entity FROM dual;
END;

But when I try to do it with help procedure I am getting a wiered error message
Error ORA-24344/ORA-06512 on PL/SQL Trigger creation
-----------
BEGIN
EXECUTE IMMEDIATE '
CREATE OR REPLACE TRIGGER VersionInsertTrigger
BEFORE INSERT ON Version
FOR EACH ROW
BEGIN
SELECT VersionSequence.nextval INTO :new.Idx FROM dual;
SELECT UID INTO :new.UserIdent FROM dual;
SELECT UPPER(:new.Entity) INTO :new.Entity FROM dual;
END;';
END;

After this error - when I re compile it is working fine.

Can someone help me how to get rid of the error.

Thanks