XSQL Error "Invalid Column Index"
423331Apr 5 2006 — edited Apr 5 2006I am getting this error returned:
<xsql-error code="17003" action="xsql:ref-cursor-function">
<statement>
RPRT_USR.ESF_INDEX.TEST_SECTOR( '01010000,01010200,01010202' );
</statement>
<message>Invalid column index</message>
</xsql-error>
When i am calling this function:
FUNCTION TEST_SECTOR
(
p_mrkt_sctr IN ANESTEDTABLETYPE
)
RETURN TEST_SECTOR_REFCURSOR
IS
select_uda TEST_SECTOR_REFCURSOR;
v_query VARCHAR2 (2000);
BEGIN
v_query := 'SELECT
d.name deal_name,
d.deal_id,
d.mrkt_sctr_id,
d.web_display,
cntry.cntry_nm deal_cntry,
ms.mrkt_sctr_desc,
t.tranche_id id,
t.class_name,
crncy.crncy_cd,
crncy.crncy_id
FROM
ESF.deal d,
ESF.TRANCHE t,
fii_core.crncy crncy,
fii_core.MRKT_SCTR ms,
fii_core.CNTRY cntry
WHERE
t.model_id is not null
AND d.deal_id = t.deal_id
AND d.mrkt_sctr_id = ms.mrkt_sctr_id
AND d.cntry_id = cntry.cntry_id
AND t.trnch_perf_data_crncy_id = crncy.crncy_id
AND d.grp_typ_id = 11';
IF p_mrkt_sctr IS NOT NULL AND (p_mrkt_sctr.COUNT > 0 AND NOT p_mrkt_sctr(1) IS NULL)
THEN
v_query := v_query || ' AND ' || mrkt_sctr_clause(p_mrkt_sctr, 'd.');
END IF;
v_query := v_query || 'AND (-1 in (-1) OR d.cntry_id in (-1) )
ORDER BY d.name, t.class_name';
OPEN select_uda
FOR v_query;
RETURN select_uda;
END TEST_SECTOR;
Where ANESTEDTABLETYPE is:
CREATE TYPE ANESTEDTABLETYPE AS TABLE OF VARCHAR2(2000);
Any help would be greatly appreciated.
Thank you