ODBC call failed on concurrent queries

[nphani]

Hey Friends,

I have an application written in VBA with Oracle backend. You can add a record in Oracle through VBA frontend. This addition of record involves querying for new record's number and then inserting etc. Everything works fine if only one user is creating a new record. But if 2 or more users create the record at exactly the same time, "ODBC -- call failed" error comes up. I could get around this problem by adding an error handler in VBA which repeats the process everytime it gets this error. But I am not clear why Oracle is not able to handle more than 1 users executing the same query at exactly the same time.

Is there any parameter that needs to be set for such handling? Is this error coming because of SELECT query or because of INSERT and UPDATE queries that are running after the SELECT?

Can somebody pls throw some light on it...

Thanks,
Phani

 

[sem]

Oracle can and does executes multiple queries. Look for the error in application. In most cases this is produced by code written by ex-SQLServer developers knowing nothing about Oracle sequences and using tables for generating sequence numbers not thinking about possible locking issues. The problem may have another origin but in any case this is not Oracle issue.

Regards, Dima

http://seminihin.narod.ru