All Overloading Functions inside the Package are not Extracted .

While doing extraction for Packages, if we have multiple overloaded functions present in the Package Body only the last function coming in sequence of extraction is getting extracted and rest others are not part of extraction.

Package functions are been extracted into specific files with naming convention as :

<package_name>.<function_name>_package.sql.

I think as we generate single files for specific function, when we have multiple functions with same name they are getting over-written in same file and only function getting extracted last with same name is getting placed in the file.

Is there any possibility if we change method from replace mode to append mode. this way we may have multiple functions with same name extracted in same file.

Start with the package extraction logic and the naming convention for generated <package_name>.<function_name>_package.sql files. Reproduce the issue using an Oracle package body with multiple overloaded functions sharing a name, then inspect whether the generated file contains every function rather than only the last one. Done means all overloaded functions are preserved in the extraction output.