darold
Issue when transfer a package with procedure definition in function definition
When I tried to export a oracle PACKAGE to pgsql, it only exported some procedure, but ignored the other function and package body.
And when I commented the procedure definitions, other package body and functions are exported correctly.
The oracle sql defined like this structures:
PACKAGE start FUNCTION start FUNCTION body, with PROCEDURE definitions, FUNCTION end PACKAGE end
only when procedures removed, the remained parts can be converted correctly.
Is this a known issue?
and when I tried to export as FUNCTION type, and with -i directive (not connected to oracle database), the whole function with procedures could be converted.
yes embedded functions or procedures in other stored procedures are not supported, the solution is to extract embedded function and create them as standalone function. This can be done in Oracle or in the source DDL file to parse using the -i option.
