Error when using Stored Procedure

0 Answers 3 Views
DataSources General Discussions Report Designer (standalone) Report Parameters
Ravi
Top achievements
Rank 1
Ravi asked on 13 Jun 2025, 09:10 PM

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.

No answers yet. Maybe you can help?

Tags
DataSources General Discussions Report Designer (standalone) Report Parameters
Asked by
Ravi
Top achievements
Rank 1
Share this question
or