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' [email protected] [firebird-support] <[email protected]>: > > > > > 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 [email protected] > [firebird-support] <[email protected]>: > > 17.10.2017 20:12, Jorge Andres Brugger [email protected] > [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 > > > > > > > > > > > >
