TORASQL uncommitted data

rjd · Post by **rjd** » Wed 17 Jan 2007 06:46

Hi,

Is there a limit to the amount of uncommitted data for a given session. I'm using the TOraSQL to insert 1000's of rows. The problem that I'm encountering at the moment is that it hangs on a call to TOraSQL.Execute. Calls earlier within the procedure to TOraSQL.Execute work fine but after about 20000 entries (4 * integer fields) the next call with 2000 entries (25 mixed fields) just hangs. It works fine if I commit after every .execute but I want to commit all data within one transaction.

Any ideas would be appreciated. Using Delphi 2006 and Delphi 2006 compatible components.

Cheers,
Rob.

Challenger · Post by **Challenger** » Wed 17 Jan 2007 12:49

There are no such restrictions. Please send to ODAC support address complete sample that demonstrates this problem including script to create server objects.