ora-00936 INSERTING record on table with 1 CLOB field

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
tuscho
Posts: 1
Joined: Thu 18 Aug 2005 12:00
Location: Brazil

ora-00936 INSERTING record on table with 1 CLOB field

Post by tuscho » Thu 18 Aug 2005 12:05

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

Aditional information of ora-00936

Post by Guest » Thu 18 Aug 2005 12:14

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
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Mon 22 Aug 2005 07:21

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.

Post Reply