Cursor with return options for Stored procedure query

raaj_help · New User Joined: 05 Jul 2006 Posts: 1

having any idea about cursor with return options for stored procedure??
please advice.

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

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