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

execution of plsql proc


DECLARE
    c_zero constant integer := 0;
    c_success constant varchar(10) := 'success';
    o_rc       NUMBER := c_zero;
    o_reason   VARCHAR2(200) :=c_success;
 
BEGIN
     
    DBMS_OUTPUT.enable(1000000);
    cq_pdr_send_email_notify_pkg.pdr_send_email_pr(o_rc, o_reason, 'pdr_program',
                                               1699380,
                                               'DEAL_EXPIRE_5_DAYS',
                                               1,
                                               NULL,
                                               NULL,
                                               NULL,
                                               NULL,
                                               NULL,
                                               NULL
                                              );

    DBMS_OUTPUT.put_line(o_rc || o_reason);
END;
/


run the above proc in sqlplus its showing

100ORA-01403: no data found

PL/SQL procedure successfully completed
0
thota198
Asked:
thota198
  • 3
1 Solution
 
slightwv (䄆 Netminder) Commented:
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.
0
 
slightwv (䄆 Netminder) Commented:
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"
0
 
thota198Author Commented:
i will be using different titles
so wht should i do to get the solution for the query i posed
0
 
slightwv (䄆 Netminder) Commented:
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.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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