ORA-01000 In TOracleQuery

[stantonw]

When I run the following I see that the cursor is not being closed in Oracle. I am running Oracle 11.2.0.3 and DOA 4.11.
Any suggestions on what I am doing wrong?

Query := TOracleQuery.Create(nil);
Query.Scrollable := False;
Query.Session := OraSession;
Query.SQL.Add('delete bf_account_balance');
Query.SQL.Add('where account_name=:account_name');
Query.DeclareVariable('account_name', otString);
Query.SetVariable('account_name', Username);
Query.Execute;
Query.Close;
Query.Free;

 

[Marco Kalter]

The cursor is closed, but you will not immediately see it on the server. If you subsequently open a new cursor, you will see that the open cursor count will not increase.