Exception handling via output parameter in SP in cognos8

When a stored procedures is called in a report, how do you handle exception handling you can add in the PL/SQL when an error has occurred?
Can cognos handle output parameters? If yes, what is the syntax in the stored procedure to generate it and send it back?
fierskenAsked:
Who is Participating?
 
fierskenAuthor Commented:
I will close the question as it has not given anything back that I can use to make it work.
0
 
RWrigleyCommented:
For a stored procedure to be used by Cognos, it needs to return a single dataset .  There is no mechanism on the Cognos side to handle anything else.
0
 
fierskenAuthor Commented:
Does this mean you can only have the out/in refcursor for the resultset and not for the exception handling in the stored procedure, even if you give back the resultset columns with '0' as content?

I don't understand why cognos treats a stored procedure differently.

Also no chance for an output parameter?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.