[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2001-07-24
1
Medium Priority
?
362 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Problem How to write an Xquery that works like a SQL outer join, providing placeholders for absent data on the outer side?  I give a bit more background at the end. The situation expressed as relational data Let’s work through this.  I’ve …
The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

656 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