Subject Re: [firebird-support] "Invalid Cursor State"
Author Jorge Andres Brugger
Sean:
It´s an executable procedure which returns a parameter. It´s not a selectable procedure.
Its the kind of SP you invoke like "execute procedure ... returning values ..." while selectable ones are usually called as "select ... from stored_procedure_name"
I´ve managed to fix my issue, anyway.
Thanks!

2017-10-17 17:47 GMT-03:00 'Leyne, Sean' Sean@... [firebird-support] <firebird-support@yahoogroups.com>:


 

Dimitry:
I do it all the time ... (read output parameters from executable procedures, using "call executable_sp" by ODBC). No issues with other SPs.

 

<SL> Unless I missed something, your SP is missing the required SUSPEND to make the SP selectable.

 

 

Regards

 

 

 

2017-10-17 15:38 GMT-03:00 Dimitry Sibiryakov sd@... [firebird-support] <firebird-support@yahoogroups. com>:

17.10.2017 20:12, Jorge Andres Brugger jorge.brugger@... [firebird-support] wrote:
> What am I doing wrong?

   You cannot fetch from non-select query.


--
   WBR, SD.


------------------------------ ------

------------------------------ ------

++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++ ++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/ resources/documents/

++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++ ++++++
------------------------------ ------

Yahoo Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/ firebird-support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/ firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-support-digest@ yahoogroups.com
    firebird-support-fullfeatured@ yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    firebird-support-unsubscribe@ yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/ us/yahoo/utos/terms/