What version of oracle u are using?
Probably u have to use dynamic sql for execute ur insert statment.