return error for ddl in create proc statements

return error for ddl in create proc statements #8064