thota198
asked on
Breakpoint in the statement while running
Is the below statement correct i.e. it returns v_deal_cnt as 0 when it is null and in exception too. When i run the procedure im getting the breakpoint in the line tht i brightened
BEGIN
v_deal_cnt := i_deal_quote_array.COUNT;
IF v_deal_cnt IS NULL THEN
v_deal_cnt := 0;
END IF;
EXCEPTION
WHEN OTHERS THEN
v_deal_cnt := 0;
END;
Last Comment
ASKER
if u see in the code its given v_deal_cnt is null then v_deal_cnt is 0 and in exception also its the same i couldnt get the logic does tht mean if deal cnt is null ya null it is 0
That doesn't explain how i_deal_quote_array is declared and populated.
Are you asking why the count is null? I'm not understanding what the question is.
Are you asking why the count is null? I'm not understanding what the question is.
ASKER
i was kind a confused since when the deal cnt is null and not null the v_deal_cnt is 0 i was not sure if it can be like tht i thought if the deal cnt is not null may be the v_deal_cnt is not 0
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Oracle Database
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
I'm not sure I understand what you are asking.