PL/SQL
From: Raymond Lee <mghong_at_pl.jaring.my>
Date: Wed, 16 May 2001 22:37:49 +0800
Message-ID: <RI8COzbcJ92i+x1DzJWyfr0d9R4F_at_4ax.com>
Date: Wed, 16 May 2001 22:37:49 +0800
Message-ID: <RI8COzbcJ92i+x1DzJWyfr0d9R4F_at_4ax.com>
Hello
[Quoted] How can I code a PL/SQL with a constant variable. For example I have a constant list of status code = "A,B,C,E,F,G,H'
In my package , among some of the module ,I might need this constant to perform my status code checking , how can I simplify it ?
Actually can Oracle declare a constant such as this or not
status_code CONSTANT varchar2:=('A','B','C','D','E','F');
...
..
.
.
.Procedure check_date
if status NOT IN status_code THEN
MESSAGE ('AAAA');
end
Is it possible ? Received on Wed May 16 2001 - 16:37:49 CEST