Im getting the "single-row subquery returns more than one row" error when using a stored procedure as a datasource.
This is the beginning of the procedure that I am calling from the report:
create or replace PROCEDURE get_idoc_report (
pStart_Date IN DATE,
pEnd_Date IN DATE,
pPrepMethod IN VARCHAR2,
pAnalyticalMethod IN VARCHAR2,
pInstru IN VARCHAR2,
pMatrix IN VARCHAR2,
pPrepAnalyst IN VARCHAR2,
pAnalyticalAnalyst IN VARCHAR2,
pWO IN NUMBER,
pWO_ID IN VARCHAR2,
pAR IN VARCHAR2,
p_cursor OUT SYS_REFCURSOR
)
IS
BEGIN
OPEN p_cursor FOR
select distinct
to_char(sysdate, 'MM/DD/YYYY') as Current_Date,
to_char(pStart_Date, 'MM/DD/YYYY') as WO_Start, ......
I have run the procedure in SQL Developer using a record to get data from the cursor, and it returns the expected number of data rows. I have used the same query as a Text select datasource query in Telerik and it worked. Any idea why I am getting the "single-row subquery returns more than one row" ? I am thinking Telerik Standalone is not able to access the rows returned from the sys_refcursor output. Any help is appreciated. I have attached the procedure text and a screenshot of the datasource setup.
Using Telerik Report Designer Version 17.1.23.606 and Oracle Database 19C.