Listing 1. This procedure reports an ambiguous overloading.

PROCEDURE cc_report.ambig_ovld (
   owner_in          IN   VARCHAR2
  ,package_name_in   IN   VARCHAR2
  ,object_name_in    IN   VARCHAR2
  ,overload1_in      IN   PLS_INTEGER
  ,startarg1_in      IN   PLS_INTEGER
  ,endarg1_in        IN   PLS_INTEGER
  ,overload2_in      IN   PLS_INTEGER
  ,startarg2_in      IN   PLS_INTEGER
  ,endarg2_in        IN   PLS_INTEGER
)
IS
   PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
   INSERT INTO cc_ambig_ovld_results
               (object_name, package_name, owner, overload1
               ,startarg1, endarg1, overload2, startarg2
               ,endarg2
               )
        VALUES (object_name_in, package_name_in, owner_in, overload1_in
               ,startarg1_in, endarg1_in, overload2_in, startarg2_in
               ,endarg2_in
               );

   COMMIT;
EXCEPTION
   WHEN OTHERS
   THEN
      ROLLBACK;
END;
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