Hello
I created a stored procedure report in Impromptu 6.0, that calls a stored procedure in an Oracle package. The stored procedure has some input parameters and a REF CURSOR output parameter. It is working.
The problem is that some of the input parameters (with datatype DATE and NUMBER) are optional. The stored procedure tests if the parameters are NULL and returns the results accordingly. I want to filter the report by a date range (on one of the table columns) or by a number range (on another column).
But when I run the report, Impromptu does not accept empty prompts for these parameters.
Is there a way to do it, besides creating a new parameter in the procedure to define if I want to filter by date or by number ?
Regards,
Ronald
I created a stored procedure report in Impromptu 6.0, that calls a stored procedure in an Oracle package. The stored procedure has some input parameters and a REF CURSOR output parameter. It is working.
The problem is that some of the input parameters (with datatype DATE and NUMBER) are optional. The stored procedure tests if the parameters are NULL and returns the results accordingly. I want to filter the report by a date range (on one of the table columns) or by a number range (on another column).
But when I run the report, Impromptu does not accept empty prompts for these parameters.
Is there a way to do it, besides creating a new parameter in the procedure to define if I want to filter by date or by number ?
Regards,
Ronald