thota198
asked on
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_p
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
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"
For this I might have gone with something like "ORA-01403: no data found in a procedure"
ASKER
i will be using different titles
so wht should i do to get the solution for the query i posed
so wht should i do to get the solution for the query i posed
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The fact that it gracefully exits means the error is being handled in an exception handler.