maybe this question is asked before, but i couldn't find it here.

If I type in the following Select in DBExplorer
"SELECT * FROM BNULL FOR UPDATE".
it comes up with this Message:
Error-Message: "ORA-01002: Fetch on an invalid Cursor". (translated from
German)

We are using ORACLE 8.1.7.0.0 with BDE 5.1 and SQL-Links

Is this a known Problem? What can we do to get the Statement working?

thanks in advance
Rolf

Most probable reason of this error is, that you going to fetch
data from cursor after commit. If to translate this words to
Delphi <g>, it will mean:

Query1.SQL.Text := 'SELECT * FROM BNULL FOR UPDATE';
Query1.Open;
Database1.Commit;
while not Query1.Eof do
    Query1.Next; // here you can get ORA-01002

Good luck,
Dmitry

--
===========================================
Dmitry L. Arefiev, software developer
Author of NCOCI8 - Freeware Delphi to Oracle8i direct access

ICQ: 50741007
EMail: daref...@da-soft.com
WWW: http://www.da-soft.com