?
Solved

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

Posted on 2001-07-24
1
Medium Priority
?
355 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

Docker-Compose to Simplify Multi-Container Builds

Our veteran DevOps Author takes you through how to build a multi-container environment, managed with a single utility in order to simplify your deployments.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
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 Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month14 days, 5 hours left to enroll

801 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