Listing 3: This procedure retrieves results from the results table.

Listing 3. This procedure retrieves results from the results table.

1 PROCEDURE retrieve_results
2 IS
3 BEGIN
4 EXECUTE IMMEDIATE
5 'SELECT * FROM cc_ambig_ovld_results'
6 || ' '
7 || c_where_clause
8 BULK COLLECT INTO l_ambig_ovld_results
9 USING l_names.owner
10 ,l_names.package_name
11 ,l_names.object_name
12 ,l_names.object_name
13 ,l_names.package_name
14 ,l_names.object_name;
15* END;