insert command do not work on MII

[Former Member]

I have the following insert command in a Fixed SQL action:.

insert into SOLICITACAO

(USUARIO_CRIADOR, LOCAL_ORIGEM, CAPACIDADE, SITUACAO, DATA_CRIACAO, TIPO, USUARIO_SOLICITANTE)

values

(1, 1, 25, 'A', TO_DATE('10-10-2009 12:33:33', 'DD-MM-YYYY HH24:MI:SS'), 'M', 1)

This insert command works with no problem when I execute it using some software to connect to my oracle database.

Inside MII I have an error:

com.sap.xmii.Illuminator.logging.LHException: SQL error has occurred on query ORA-00900: invalid SQL statement

What could be wrong here?

Nuno Cunha

[Former Member · Accepted solution]

I you need to use a command query instead of a fixed query.

[Former Member · Accepted solution]

Hi,

Oooops! Thank you very much.

Nuno Cunha