troubleshooting Question

Breakpoint in the statement while running

Avatar of thota198
thota198 asked on
Oracle Database
5 Comments1 Solution391 ViewsLast Modified:

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;
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros