ORA-24334: no descriptor for this position.

[SYBPBPROGRAMMER]

I'm using PB 10.5 with Oracle 10i. I'm trying to create a datawindow with a stored procedure as its source but when I click on 'Finish' button in the datawindow wizard, I get the oracle error ORA-24334 which is talking about not having some descriptor handle.

I have other datawindows that are based on exactly similar stored procedures and they don't give me any problem.

 

[mbalent]

Are the other dws from older versions of PB and were migrated? Take a look at the exported script from the dws (one that works and one that does not). I've had to remove ';1' from the end of the stored proc call in the dw export to get some of mine to work.

Matt

"Nature forges everything on the anvil of time

 

[SYBPBPROGRAMMER]

Thanks for last response

This error pops up the moment I hit Finish when creating the datawindow. So exporting is ruled out as the datawindow is not created at all. the other datawindows were created in the same version... in fact just a day earlier..

I am still able to recreate the simillar Datawindow that works.. But different return cursor.. see below.

SP that WORKS as a source to DW

CREATE OR REPLACE Procedure SP_STANTON_STATION_YTD ( startdate in date, enddate in date,
cur_out in out PLANT_PERF.STANTON_YTD.TEMP_STANTON_STATION_YTD_RTN) is
MAX_PEAK_LOAD NUMBER(6,2);
PEAK_LOAD NUMBER(6,2);
PEAK_DATE DATE;
LOAD_FACTOR NUMBER(9,2);
FUEL_OIL_IN_STORAGE NUMBER(9,2);
BEGIN
:
:
:
:
OPEN cur_out FOR SELECT * FROM PLANT_PERF.TEMP_STANTON_STATION_YTD;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
END;



-------------------------------------------------

SP that DOES NOT WORK as a source to DW


CREATE OR REPLACE Procedure SP_ER_STATION_YTD ( startdate in date, enddate in date,
cur_out in out PLANT_PERF.ER_YTD.TEMP_ER_STATION_YTD_RTN) AS
TEMP_IN_1 NUMBER(6,2);
TEMP_IN_2 NUMBER(6,2);
TEMP_IN_3 NUMBER(6,2);
TEMP_OUT_1 NUMBER(6,2);
TEMP_OUT_2 NUMBER(6,2);
TEMP_OUT_3 NUMBER(6,2);
AVG_PRESS_1 NUMBER(6,2);
AVG_PRESS_2 NUMBER(6,2);
AVG_PRESS_3 NUMBER(6,2);
INV_AT_0 INTEGER;
INV_AT_24 INTEGER;
BEGIN
:
:
:
:
:
OPEN cur_out FOR SELECT * FROM PLANT_PERF.TEMP_ER_STATION_YTD;

EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;

END;