View previous topic :: View next topic
|
Author |
Message |
raaj_help
New User
Joined: 05 Jul 2006 Posts: 1
|
|
|
|
having any idea about cursor with return options for stored procedure??
please advice. |
|
Back to top |
|
|
red_roses
New User
Joined: 31 Oct 2005 Posts: 27
|
|
|
|
Cursor with the 'WITH RETURN' option is used in case of stored procedures.
If a cursor is defined with this clause. the SP only have to Open the cursor. and the resultset is returned to the calling pgm.
no need to Execute the 'fetch cursor' statment in this case |
|
Back to top |
|
|
damodar
New User
Joined: 10 Aug 2006 Posts: 1
|
|
|
|
Hi,
I am receiving -805 error(bind related) when I try to fetch data in the main program(calling) from a cursor that is opened in stored procedure. I have received 466 code as expected after returning from stored procedure but having problem in fetch. Can you help me to resolve this issue?
Thanks |
|
Back to top |
|
|
|