Eclipse Community Forums: BIRT » BIRT report params and handling report errors?

Help

Home

Home » Archived » BIRT » BIRT report params and handling report errors?

Show: Today's Messages :: Show Polls :: Message Navigator

BIRT report params and handling report errors? [message #368653]

Wed, 17 June 2009 15:19

Dean Hiller

Messages: 46
Registered: July 2009

Member

I have a few questions.

1. How do I make it so a report can hand back an error to the java code
and
if there is an error, then abort doing the report and redirect to an
html page that might say "Sorry, there is no data for this report with the
parameters entered". Is there wa way in the stored proc to pass something
and then in java to get that and make it abore or is there a way to throw
an exception from the stored proc or something? I have no idea how ot do
this. We are in oracle right now.

2. I have created my own stored procs and hooked them all to BIRT and they
all work very great, but when I hook it to our actual stored proc which is
much
more complext, the output parameter list is wrong and shows one single
output column of ":B2||::||:B1" which is weird. Anyone see this before?

I even copied the stored proc into a new one, deleted all the body keeping
the interface the same and then implemented simple select statement and
that one
worked fine with BIRT.

3. How does BIRT discover the output columns anyways? maybe I can debug
some more on that end.

thanks,
Dean

Report message to a moderator