the semi colon goes after the final ' in the statement. Plus that query is a little silly anyway On 1/24/06, raja rao <raja4list@xxxxxxxxx> wrote: > > > when the below is run i am getting the error. can someone help me : > > begin > execute immediate ' select sysdate from dual ;' > end ; > >