SQL statment => insert select

[Miquel Angel Bada Zuazo]

I'm creating an Insert SQL statment woth the result of a selectsentence, 

it works fine as a SQL statment, but when I tray to execute with
IBatis, i don't know why, but it isn' executed, and there are no error
...

does anybody knows if I can execute the following statment?


<typeAlias alias="copiarPlantilla" type="stacks.domain.agenda.CopiarPlantilla"/>

        <insert id="insertItemCopiarPlantilla" parameterClass="copiarPlantilla">
                INSERT INTO stk_plantillas_horarios
                (PLA_ID, ACT_ID, IND_ID, DIASEMANA, HORA)
                SELECT #agendaAlId#, ph.ACT_ID, ph.IND_ID, #diaSemana#, ph.HORA
                FROM stk_plantillas_horarios ph
                WHERE ph.PLA_ID = #agendaDeId#
                AND ph.DIASEMANA = #diaSemana#
        </insert>

Sincerely Yours, 

Miquel Angel