ORA-01000

Hi, i have the folwing problem , to insert and update records i use a TOracleDataset that has a cursor variable. The TOracleDataset is calling a Oracle 8i stored procedure. For each record, i load the TOracleDataset variables and call the ExecSQL method and then i use the CloseAll method before loading the next record to be inserted.

Everthing work fine for few records but the ORA-01000 error is raised after the firts 300 records inserted.

What can i do, i have set the TOracleSession.Preferences.UseOCI7 to true but the error still happening;

Any help will be appreciated.

Regards Esteban
 
Oracle Net 8.0.x has a cursor leak bug when using cursor variables. Are you using Net 8.0.x on your 8i database?
 
Back
Top