Listing 2: The steps of the main executable section of fullset

1   BEGIN
 2     l_names := cc_names.for_program (program_in);
 3
 4     FOR rec IN distinct_programs_cur (l_names.owner,
 5                                       l_names.package_name,
 6                                       l_names.object_name
 7                                      )
 8     LOOP
 9        get_dbms_describe_info (rec);
10        l_index := l_argument_name.FIRST;
11        LOOP
12           EXIT WHEN l_index IS NULL;
13           transfer_data (rec, l_index);
14           l_index := l_argument_name.NEXT (l_index);
15        END LOOP;
16     END LOOP;
17
18     RETURN retval;
19  END fullset;
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy