Hello,

I'm getting an error while executing the following statement in an after insert trigger:

select level1,level2,level3,level4 into l1,
l2,l3,l4 from Z_Documents_Types_Levels where id = n.ParentID;

The error: SQL0104N An unexpected token "l1" was found following "2,level3,level4 into"

Is this a syntax error and if so what is the correct way to do it ?

Thanks

Yes this is a syntax error, and the correct way of doing it would be to look up the correct syntax in the manual.

In an "after insert" trigger you probably want to do either an insert or an update of an (other) table.

"Select .. INTO" is only used in embedded SQL, not typically in triggers.