• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1020
  • Last Modified:

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?
0
fiersken
Asked:
fiersken
  • 2
1 Solution
 
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
 
fierskenAuthor Commented:
I will close the question as it has not given anything back that I can use to make it work.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now