#4 package and its function are not migrated (correct)

[Anonymous]

Dumping package LOADER...
Parsing function LOADER.elapsed_time...
Dumping to one file per function: ./sources/packages/loader/elapsed_time_package.sql
Parsing function LOADER.check_if_already_active...
Dumping to one file per function: ./sources/packages/loader/check_if_already_active_package.sql
Parsing function LOADER.check_if_already_active...
Dumping to one file per function: ./sources/packages/loader/check_if_already_active_package.sql
Parsing function LOADER.check_if_already_active...
Dumping to one file per function: ./sources/packages/loader/check_if_already_active_package.sql
Parsing function LOADER.preload_activate...
Dumping to one file per function: ./sources/packages/loader/preload_activate_package.sql

but the package has 4 functions (in 1 function there are 2 embedded subfunctions)

so I don't know why it isn't exctracting and migrating all functions

above times Dumping to one file per function: ./sources/packages/loader/check_if_already_active_package.sql

can you explain me why?

the package looks like:

CREATE OR REPLACE PACKAGE HOMEGATE."LOADER"
IS
--
-- Purpose:
--
-- MODIFICATION HISTORY
-- Person Date Comments
-- --------- ------ ------------------------------------------
--
--------------------------------------------------------------------

FUNCTION new_loader(...) return number ;
FUNCTION empty_valid_directories_delete(log_path varchar2) return number ;
FUNCTION suspended_agencies_delete(log_path varchar2) return number ;
FUNCTION preload_activate(log_path varchar2) return number ;

END loader; -- Package spec
/

HINT:
the function new_loader contains the to subfunction (embedded functions) elapsed_time and check_if_already_active

can this be the problem ?

Thanks

[Darold Gilles]

Hi,

The problem comes those two subfunction, this is not supported in PostgreSQL and break the Ora2Pg parser. You must defined them as main function before using Ora2Pg.

Best regards.