Skip to Content
0
Former Member
Sep 10, 2008 at 02:21 AM

JRC CR XI Rel 2 - Invalid Parameter Name: {0} using Stored Proc in Oracle

44 Views

Hello,

I've been stumped by this issue that I've been getting. I've been trying to take advantage of stored procs to filter the result set before returning to CR instead of using views, which relies on most of its filtering on the crystal reports side.

I've followed the process of creating the strongly bound cursor, then including an "in out" parameter along with 5 other "in" parameters in the stored proc. In the Java class, this is how I pass in the parameters:

        ReportClientDocument reportClientDoc = new ReportClientDocument();
        reportClientDoc.open(REPORT_NAME, 0);
        //Connection setup
        ConnectionService.getInstance().crytalReportsConnectionSetup(reportClientDoc.getDatabaseController());
        //We will be using the ParameterFieldController
        ParameterFieldController paramFieldController = reportClientDoc.getDataDefController().getParameterFieldController();
        paramFieldController.setCurrentValue("", "PARAM1", "000");
        paramFieldController.setCurrentValue("", "PARAM2", "000");
        paramFieldController.setCurrentValue("", "PARAM3", "000");
        paramFieldController.setCurrentValue("", "PARAM4", "000");
        paramFieldController.setCurrentValue("", "PARAM5", "000");

I end up getting an error:

Invalid Parameter Name:

I've tested the report itself in Crystal and it works. Is there something I'm missing?

Thanks in advance,

Jeff