Exception handling via output parameter in SP in cognos8

Posted on 2008-11-14
Last Modified: 2013-12-07
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?
Question by:fiersken
    LVL 12

    Expert Comment

    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.

    Author Comment

    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?

    Accepted Solution

    I will close the question as it has not given anything back that I can use to make it work.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now