Error usando EXECUTE IMMEDIATE

[pato819]

quedo de la siguiente forma, solo le quite la ultima variable, pongo el codigo:

consulta := 'SELECT'''||dia||''', COUNT(*) AS EXPR1 FROM '|| tabla;

EXECUTE IMMEDIATE consulta INTO tit, text;