ora-00936 INSERTING record on table with 1 CLOB field

ora-00936 INSERTING record on table with 1 CLOB field

Postby 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...
tuscho
 
Posts: 1
Joined: Thu 18 Aug 2005 12:00
Location: Brazil

Aditional information of ora-00936

Postby 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"
Guest
 

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


Return to dbExpress driver for Oracle