SSRS 2019 Not Working with ODP.NET 19c Error with Stored Procedure Calls‎

Question

SSRS 2017 does not have this issue. Upgraded to SSRS 2019 on Windows Server 2019, with .NET Framework 4.8.03761 (release 528049), Oracle 19c client_x64 and client_ODAC_x64 installed, registered ODP.NET Managed Client to GAC; add ODP.NET Managed Client entries to machine.config; as advised in "https://learn.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-ver15". Built and tested data source with simple stored procedure call to return a 2-column-1-row table, ReportingServicesService log on SSRS server shows "ORA-01006: bind variable does not exist".
DBA verified the call or query did not even reach the Oracle database.
Same report setup was working fine on SSRS 2017 with Oracle / ODAC 12.2 clients on Windows Server 2012.
CREATE OR REPLACE PACKAGE BODY ECDN_GATE.ZP_ECDN_REPORTS
AS
PROCEDURE Get_Report_Area_List (inret_list OUT cur_ref)
IS
BEGIN
OPEN inret_list FOR
SELECT CODE, NAME
FROM ECKERNEL_DVN.OV_PRODUCTIONUNIT
ORDER BY name;
END;
... ...
Should simply return:
CODE NAME
DVN_JF Devon Jackfish

Anyone had this issue, and solutions? Many thanks.

Answer 1

Hi @Michael Xu

The ORA-01006 normally occurs when you are using PL/SQL to dynamically build a SQL statement and the SQL is malformed.

I refer to this thread ，you can take a reference：t_ora_01006_bind_variable_does_not_exist.htm

When you use Dynamic SQL Statement and forget to use the bind variable, you will get this error.

I refer to this thread：ora-01006-bind-variable-does-not-exist

Hope this can help you .

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
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.