PROCEDURE-BASED BLOCK in FORMS
MTMAug 8 2012 — edited Aug 8 2012I am attempting to create a forms block (10gR2) based on a stored procedure and I am unable to get any records to display on the form after querying.
Thus far I have:
1) Created a package in which a ref cursor is defined
2) Created a procedure in that package which returns the ref cursor. The package has 2 arguments: The first is the ref cursor, defined as IN OUT. The second is a parameter used in the SELECT which populates the ref cursor.
3) Tested that the procedure by writing a separate PL/SQL routine and have proven that the procedure works and returns the expected values.
4) Using the Block Wizard, I created the Forms Block based on the procedure.
5) Set the QUERY DATA SOURCE ARGUMENTS to supply the required second argument to the procedure. The argument is hard-coded to the same value I used when testing in step 3.
When I run the form and execute the query from the menu (QUERY --> EXECUTE), absolutely nothing happens.
Where do I begin to solve this problem?
Thanks