October 2005
Intermediate to advanced
454 pages
14h 44m
English
Now that all facets of the function are in place, it’s time to take one last look at the function’s pseudo-code.
BEGIN
-- for every order...
LOOP
FETCH p_curs INTO v_order;
EXIT WHEN p_curs%NOTFOUND;
IF first revord or new region THEN
Load region criteria
END IF;
IF it's a potential repeat then add to associative array.
IF it's a repeat order then
PIPE ROW( );
END IF;
END LOOP; -- every order
RETURN;
END;The complete function code is available in the repeat_orders.sql file on the book’s web site.