Another ORA-06502: PL/SQL: numeric or value error: character to number conversion er

[LKBrwn_DBA]

DUH! Check this out:

QL> CREATE OR REPLACE FUNCTION STATUS_DESC_SF
  2  (stage_id IN NUMBER)
  3  RETURN NUMBER
  4  IS 
  5  stat_desc VARCHAR2(50);
  6  BEGIN
  7  CASE WHEN stage_id = 1 THEN 
  8  stat_desc:= 'Order Submitted';
  9  WHEN stage_id = 2 THEN 
 10  stat_desc := 'Accepted, sent to shipping';
 11  WHEN stage_id = 3 THEN 
 12  stat_desc := 'Backordered';
 13  WHEN stage_id = 4 THEN
 14  stat_desc := 'Cancelled';
 15  ELSE stat_desc := 'Shipped';
 16  END CASE;
 17  RETURN stat_desc;
 18  END;
 19  /