View previous topic :: View next topic
|
Author |
Message |
Lenny2113
New User
Joined: 20 Dec 2009 Posts: 2 Location: USA
|
|
|
|
Hi all,
I have a UDB Stored Procedure which has "Select into". It returns -811 and does not retrieve any rows into host variables.
Any suggestions why? (Besides cursor)
Thanks |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
because an -811 (in release vsn7 and above)
does not populate any host variables. |
|
Back to top |
|
|
Lenny2113
New User
Joined: 20 Dec 2009 Posts: 2 Location: USA
|
|
|
|
Thank you! Will do cursor |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
glad we were able to help. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Sorry it took me so long to think of it,
but you can put a:
FETCH FIRST ROW ONLY
clause in the singleton select and you don't have to deal with cursors. |
|
Back to top |
|
|
|