Using XSQL; ORA-01008: not all variables bound using <xsql:ref-cursor-function>?

My attempts to run this ref-cursor fail.  Eventially I will add variables passed into this function to narrow search results down based on JSP input form, but for now I'd like to get one of the cursors working first.  I'd like to know how I get around this error/what am I doing wrong.  The stor-procs are created by the Database team.

<?xml version='1.0'?>
<?xml-stylesheet version="1.0" type="text/xsl"?>
<xsql:ref-cursor-function connection="SEVPDatabase" xmlns:xsql="urn:oracle-xsql">

  all_status.get_fm_status(:cv)
<!-- this was used with/without :cv)-->

</xsql:ref-cursor-function>

This is the ref-cursor:

CREATE OR REPLACE PACKAGE ALL_STATUS AS
TYPE GET_STATUS IS REF CURSOR;
PROCEDURE GET_FM_STATUS
(
 V_GET_STATUS                 OUT GET_STATUS);
PROCEDURE GET_J_STATUS
(
 V_GET_STATUS                 OUT GET_STATUS);

END ALL_STATUS;
/
CREATE OR REPLACE PACKAGE BODY ALL_STATUS IS
PROCEDURE GET_FM_STATUS
(
 V_GET_STATUS                 OUT GET_STATUS)
 IS
       
        BEGIN

                OPEN V_GET_STATUS FOR SELECT
          A.VC_CD_COA, A.LNAME, A.FNAME, A.MNAME,
                A.CTC_CD_CITIZEN_OF, B.PROG_BEG_DT,
                B.PROG_END_DT, B.CURRENT_IND
                FROM CIP_NONIMMIGRANTS A, CIP_ELIGIBILITIES B
                WHERE A.ID = B.NI_ID;

END GET_FM_STATUS;
 

END ALL_STATUS;
/
CZLONG1Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
MoondancerConnect With a Mentor Commented:
I have refunded your 50 points to you for this and will move it to the PAQ to close it due to the age and no activity.  If the question is still active for you, please post it again to draw current attention.

Also, check the ALL TOPICS link below for new Topic Areas that were added today.  The HELP DESK link on the left is very helpful for site related questions.

Moondancer
Community Support Moderator @ Experts Exchange
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.