11 Replies Latest reply on Aug 20, 2013 12:33 PM by Billy~Verreynne

    Package Constant variable in CASE

    Aparna16


      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