Solved

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

Posted on 2001-07-24
1
335 Views
Last Modified: 2007-12-19
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;
/
0
Comment
Question by:CZLONG1
1 Comment
 
LVL 1

Accepted Solution

by:
Moondancer earned 0 total points
ID: 6790024
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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

The Client Need Led Us to RSS I recently had an investment company ask me how they might notify their constituents about their newsworthy publications.  Probably you would think "Facebook" or "Twitter" but this is an interesting client.  Their cons…
Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now