If you are unable to create a new account, please email support@bspsoftware.com

 

Error generated in Report using SP as Query Subject when refcursor returns NULL

Started by ratul.dey, 25 Sep 2006 06:00:53 AM

Previous topic - Next topic

ratul.dey

Hello,
I am using ReportNET 1.1 MR2
I am into building some reports involving some prompts.
Say one of my report runs and displays total transactions done in
a department for a particular "report run date".
The report runs smoothly for a particular date say,
09/08/2006(MM/DD/YYYY format) since data is available for that date.
We are using an SP as the query subject and the SP takes in date
as one of its parameters.
When we test the SP in PL/SQL developer for a particular date we
get the cursor results when Data is available.This is quite
understandable.

What we require is that when we run the report , which uses this
same SP as query subject , when there is NO data for a
particular Prompt value entered and the refcursor returns NULL,
the report should also display a Blank page with the static
items like Report name, Headers, Columns names,etc present.
Instead the report when for a prompt value which returns NULL in
SP refcursor, the report does not run , rather it throws an
error as this ---

"DPR-ERR-2082 An error has occured. Please contact your system
administrator. The complete error has been logged by CAF with
SecureErrorID...."


The actual error message as retrieved from the Audit Folder says
----

"QE-DEF-0177 An error occurred while performing operation
'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation
"APICursor::OpenResult" is inactive.
UDA-SQl-0283 Metadata describing "PLCS103_DAILY_ONLINE_AIGC_SP"
does not match results from the database."

(PLCS103_DAILY_ONLINE_AIGC_SP is the name of our report).

Please suggest a means by which we may have reports displaying
simply a Blank page for refcursor returning NULL (As from user
perspective this error has got no meaning).