Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Ref Cursor Does not Populate Block

452570Sep 25 2007 — edited Sep 25 2007
Database 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2007
Added on Sep 25 2007
3 comments
548 views