This discussion is archived
11 Replies Latest reply: Aug 20, 2013 5:33 AM by BillyVerreynne RSS

Package Constant variable in CASE

Aparna16 Newbie
Currently Being Moderated


Hi,

Below SQL query (for making a view) is not working.

 

CASE WHEN IN_TYPE = PKG_CONSTANTS.INV_TYPE_1

     then 'New'

  WHEN IN_TYPE = PKG_CONSTANTS.INV_TYPE_2

  THEN 'old'

  ELSE 'N/A'

   end as Status

 

PKG_CONSTANTS.INV_TYPE_1 ==> PKG_CONSTANTS is a package and INV_TYPE_1 is a constant variable.

 

INV_TYPE_1   CONSTANT VARCHAR2(10) := '55600';

INV_TYPE_2   CONSTANT VARCHAR2(10) := '55601';

 

error: oracle.dbtools.raptor.controls.sqldialog.ObjectActionController$EditorObjectActionListener .. some 10 similar errors are coming in Loggin Page of SQL Developer

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points