Databases Reference
In-Depth Information
Listing 10-15.
The VALIDATE_ORDER_ADJUSTMENTS Function
create or replace function validate order adjustment
--
-- function to validate adjusted order
--
return varchar2
as
l message varchar2(32767) default null;
l number integer;
l valid numbers boolean := true;
begin
for i in 1..apex application.g f01.count loop
--
-- validate price (g f02): cannot be null or non-numeric
--
if apex application.g f02(i) is null then
l message := l message ||
'<li>Please specify a Price value '||
'in row #'|| i ||'.';
else
begin
l number := to number( apex application.g f02(i) );
exception when others then
--
-- add error text to return message
--
l message := l message ||
'<li>The Price in row #'|| i ||
' must be a whole number.';
--
-- flip valid numbers flag to avoid
-- processing error below
--
l valid numbers := false;
end;
end if;
--
-- validate quantity (g f03): cannot be null or non-numeric
--
if apex application.g f03(i) is null then
l message := l message ||
'<li>Please specify a Quantity value '||
'in row #'|| i ||'.';
else
begin
l number := to number( apex application.g f03(i) );
exception when others then
--
-- add error text to return message
--
