search

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
http://www.ora2pg.com/
GNU General Public License v3.0
1.03k stars 341 forks source link

All Overloading Functions inside the Package are not Extracted . #985

Open jagmohankaintura-tl opened 4 years ago

jagmohankaintura-tl commented 4 years ago

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.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.
naveenjul29 commented 4 years ago

I am second on this, me too got the same problem. only the last method(overloaded) got exported inside the package.

darold commented 4 years ago

Yes this is the problem when using hash to store the definition with a key based on package name and function name, the last parsed overloaded function erase all other definitions. It is in my todo list.