Subject Re: [ib-support] How to return multiple rows from SP?
Author Helen Borrie
At 02:56 AM 13-09-02 +0000, you wrote:
>I've read the Firebird documents but I'm not clear anymore. I wrote a
>stored procedure by sending one parameter to retrieve multiple rows. It
>works when I execute by ISQL but it showed an error on Delphi
>== "Error Creating Cursor Handle".... I connected to Firebire database
>directly via BDE. Do anyone have any idea or suggestions for me???
>I have many SPs do like this...

Delphi gives that error when you try to select from a SP that does not
generate a dataset. In particular, focus on FOR SELECT...INTO....DO...

Read up the documentation in the LangRef about Selectable Stored Procedures.