ora-00936 INSERTING record on table with 1 CLOB field

[tuscho]

Hi there.

I hava a master/detail routine, that i am having troubles, when a ApplyUpdates occurs.

My master table have a CLOB field. In the same transaction I insert the master record and beside this, the detail. When i call the apply update for the detail, this error message occurs.

If if perform a drop column on the CLOB field from the master table, the erros doesn´t occurs anymore...

Can U help me?

Tks a lot...

[Guest]

The log from TSqlMonitor shows more information of error reported:



SELECT ID_MTMS_GRAC.NEXTVAL FROM DUAL

insert into MTMS_GRAC
( ID , NOME , CHAVE , COMANDOS , FD )
values
(:1, :2, :3, EMPTY_CLOB(), :4)
RETURNING
COMANDOS
INTO
:5
:1 (String[2],IN) = '47'
:2 (String[13],IN) = 'dfghghygvbvbh'
:3 (Char[1],IN) = '1'
:4 (String[8],IN) = 'GrupoMGE'
:5 (Clob,IN)

insert into MGE_GRMGE
( ID , IDA , IDF_EMPRESA )
values
(:1, :2, :3)
RETURNING
INTO
:4
:1 (String[2],IN) = '19'
:2 (String[2],IN) = '47'
:3 (String[1],IN) = '1'

Error: ORA-00936: missing expression

select
ID
from MGE_GRMGE
where
ID = :1
:1 (String[2],IN) = '19'

Rollback: user "tucho", server "mtm.mult.com.br"

[Paul]

We cannot reproduce your problem with DbxOda 2.50.5, Delphi 7. I put TimpleDataSet components and link them by ID field. Possibly this problem of Borland SqlExpress components, because DbxOda does not generate SQL itself. Please check this behaviour with standard Oracle driver.
Send us please small demo project to demonstrate the problem and include script to create server objects.