SSRS2019 WITH ORACLE STORED PROCEDURE FAILS WITH WRONG NUMBER OF TYPES OF ARGUMENTS

LS2021 6 Reputation points
2021-03-16T21:58:32.4+00:00

CREATE PROCEDURE TESTLV_PROC (L_CURSOR OUT SYS_REFCURSOR)
IS
BEGIN
OPEN L_CURSOR FOR
SELECT * FROM DW_ORGANIZATION;
END;
/

78475-image.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,860 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,996 Reputation points
    2021-03-17T02:52:52.507+00:00

    Hi @LS2021 ,

    Not familiar with Oracle, so I did some online research.

    Several people who are also encountering the issue said that maybe related with the provider.

    https://stackoverflow.com/questions/12194311/stored-procedure-call-gives-an-error-pls-00306-ora-06550
    https://social.technet.microsoft.com/Forums/en-US/626c9c6c-1c99-4718-9cb1-054a102701cd/ssrs-calling-a-stored-procedure-error-pls00306-wrong-number-or-types-of-arg?forum=sqlreportingservices

    To use data from an Oracle database in your report, you must have a dataset that's based on a report data source of type Oracle. This built-in data source type uses the Oracle Data Provider directly and requires an Oracle client software component. oracle-connection-type-ssrs

    SSDT runs in 32 bit whereas SSRS runs in 64 bit. Since we are in the same system, we need to install both the bit-ness of Oracle drivers one by one.

    Oracle article for your reference: https://www.oracle.com/a/otn/docs/database/connecting-ssrs-to-oracle-adb.pdf

    Regards´╝î
    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    What can I do if my transaction log is full?--- Hot issues November

    How to convert Profiler trace into a SQL Server table -- Hot issues November

    0 comments No comments