execution of plsql proc

Posted on 2011-05-03
Last Modified: 2013-12-07

    c_zero constant integer := 0;
    c_success constant varchar(10) := 'success';
    o_rc       NUMBER := c_zero;
    o_reason   VARCHAR2(200) :=c_success;
    cq_pdr_send_email_notify_pkg.pdr_send_email_pr(o_rc, o_reason, 'pdr_program',

    DBMS_OUTPUT.put_line(o_rc || o_reason);

run the above proc in sqlplus its showing

100ORA-01403: no data found

PL/SQL procedure successfully completed
Question by:thota198
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    This means cq_pdr_send_email_notify_pkg.pdr_send_email_pr is doing a select that returns no rows.

    The fact that it gracefully exits means the error is being handled in an exception handler.
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    Since you are new to the site, you might think about adding a descriptive title and not keep using the same thing "execution of plsql proc".

    For this I might have gone with something like "ORA-01403: no data found in a procedure"

    Author Comment

    i will be using different titles
    so wht should i do to get the solution for the query i posed
    LVL 76

    Accepted Solution

    You need to look at the code of the procedure to see what is throwing the NO_DATA_FOUND exception.

    From what you posted, there is no way of knowing.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    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…
    Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    794 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