ORA-25401

[Antonio Sala]

Hi:
I've got a problem with a TOracleQuery, and a server Oracle 9i.
If I execute a select query with a TOracleDataset, it works fine, but if I execute the same query with a TOracleQuery, then no rows are returned and if I try to fetch, then I receive the error "ORA-25401 can not continue fetches"

I work with Delphi 7 and DAO 4.0.6.2

Any ideas?

Thanks and sorry for my bad English.

Antonio

 

[Marco Kalter]

There must be a difference between the SQL and/or variables of the TOracleDataSet and the TOracleQuery. The TOracleDataSet uses a TOracleQuery internally.

 

[Antonio Sala]

Originally posted by Marco Kalter:
There must be a difference between the SQL and/or variables of the TOracleDataSet and the TOracleQuery. The TOracleDataSet uses a TOracleQuery internally.

No. I have maked a simple program what includes one TOracledataset and one TOracleQuery, and into a TMemo the user writes the SQL query and with two buttons launch the query with each component, and the query works Ok with TOracleDataset and fails with TOracleQuery (it not returns any row).

Is possible what TOracleQuery use a different port in any way and if this port is closed in the server then the TOracleQuery fails?

Thanks

 

[Marco Kalter]

Like I said, there is no difference between the TOracleDataSet and TOracleQuery. Can you use the Oracle Monitor to verify the query executed and the variable values?