Getting 'Error creating cursor handle' when using TStoredProc

By: Borland Staff

Abstract: This error occurs, because the application tried to execute an SQL statement and retrieve a to execute an SQL statement and retrieve a result set that did not exist.

Problem:
When using TStoredProc and try to execute an InterBase 
stored procedure the error 'Error creating cursor handle' 
is generated.


Solution:
This error is the message that accompanies an 
ENoResultSet exeception thrown by the BDE.
This error occurs, because the application tried 
to execute an SQL statement and retrieve a 
result set that did not exist.

When using TStoredProcs with InterBase execute 
procedures  the application must use the 
TStoredProc.ExecProc method instead of the 
TStoredProc.Open method (or setting active property 
to true).

(See Data Definition Guide for more information on 
execute stored procedures)

Server Response from: ETNASC04