Article #25392: Getting 'Error creating cursor handle' when using TStoredProc

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)

Last Modified: 27-OCT-00