SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IF condition with the TO_NUMBER function?

390534Jul 22 2008 — edited Jul 22 2008

Anyone,

When I code this:

IF TO_NUMBER(var_priority_long_xf) >=0 THEN
   var_justifypriority := NULL;
ELSE
  var_justifypriority := var_priority_long_xf;
  var_priority_long_xf := NULL;
END IF;

will an error condition on the TO_NUMBER conversion (i.e. non non-numeric value being converted) push into the ELSE or will it break in my script?

I should know this but just can not recall.

Thanks.,
David Miller

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 19 2008

Added on Jul 22 2008

5 comments

627 views