Ref Cursor Does not Populate Block
452570Sep 25 2007 — edited Sep 25 2007Database Version 10.2.0.1.0
Form Designer --> Form Version Forms [32 Bit] Version 10.1.2.0.2 (Production)
I am trying to use a Ref Cursor as the source of a form's block. I used the wizard to setup the link to the procedure that returns the ref cursor. The wizard is able to identify all pf the columns being returned and there are no problems at this point. Everything works fine until I do an execute_query. At this point I get nothing. No Error message and no records displayed.
Steps taken to confirm the Ref Cursor Returned has records.
1. Set the Database Procedure to set its parameters with hard coded values and ignore the ones coming from the form to eliminate any problem with the parameters being passed.
2. Created a test procedure that does what the forms would do. Calls the database procedure to get back the ref cursor. I then fetch from the cursor and until eof. All records are present as expected.
3. Put in Logging messages in the database package to confirm the Procedure is being called. It is.
4. Before the Ref Cursor is returned to the form I fetch one record and write a value from the record into the log. This works as well.
5. Again tried my test procedure after step 4 and it now return all of the records execpt the first one (As expected since the Package did one fetch before returning the Ref Cursor).
Any ideas on why the Form Block is executing the Procedure to get the ref cursor and is getting back a ref cursor to a result set that has has records, but is not populating any records into the block?