Problems with Oracle Database 10g Express Edition

[wgodoy]

Hi,

I am using a TOracleSession with TOracleDataSet. When a post (using
CommitOnPost=true) no error rises. But when I look the data on
database (Using some dbexplorer), the data1 of field1 lost!, the data2
of field2 writes on field1, the data3 of field3 writes on field2, the
data of field4 writes on field3, and so on.

When I use Oracle 10g on linux (No express edition) works fine.

Is this some database problem?

Help me please!

Wagner Ant

 

[Marco Kalter]

This seems like some Oracle Client/Server bug. Perhaps you can change the client version to verify this?

 

[gandi]

Hallo.

I got same problem. When I 'insert into tablename (field1,field2,field3,...) values ( Value1,Value2,Value3,...)' Value1 gets lost, Value2 into field1, Value3 into field2 and field3 stays empty in the last szenario. The first three szenarios do well.

Having four szenarios:
1. BDE , OraClient 10.2.0.1, OraServer 10.2.0.1
2. DOA 4.0.6, OraClient 10.2.0.1, OraServer 10.2.0.1
3. BDE , OraClient 10.2.0.1, OraExpress 10.2.0.1
4. DOA 4.0.6, OraClient 10.2.0.1, OraExpress 10.2.0.1

Do you have any idea. I did session traces, sql-monitoring, and so on.
I'll stay in touch. In case you'll answer immediately I can provide trace- and logfiles or answer questions.
It would be very nice if you are able to help.

greeting
Andreas

 

[Marco Kalter]

Does this statement have a "returning into" clause?

 

[jochavezgomez]

Hello,

I have a similar problem. I downloaded DOA 4.0 evaluation for delphi 2006. I am testing DOA with Oracle XE on a Windows XP SP2 box.

I used TOracleSession and TOracleDataSet for a very basic entry data form. I added the rowid column to the SQL sentence in the TOracleDataSet in order to insert and modify data.

I double clicked on the TOracleDataSet and added all field. I draggged every field into a Form and placed a TOracleNavigator.

When I insert a new record by using the form and the TOracleNavigator and post it to the database, the record is saved, but the data of field1 is lost, field 1 contains the values on field2 and so on... However, the value insterted for the key field is correct.

This behavior only happens when I insert a record.

I would appreciate your help Marco.

 

[gandi]

@Marco Kalter: No, it doesn't.

@All:
We fixed this problem. It was with NLS-Settings. So, try to set your clients charset same as your server.