Package ported from Oracle - ERROR: not executed, package body does not exist

Highlighted
Adventurer

Package ported from Oracle - ERROR: not executed, package body does not exist

Used MTK to migrate a schema from a Oracle database, but then noticed in the target EDB schema the stored package ported only contains the package spect but no package body.  Try to run it will result in:

"ERROR:  not executed, package body does not exist".  Did I miss anything when I ran runMTK.sh ?

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

3 REPLIES 3
Highlighted
Moderator

Re: Package ported from Oracle - ERROR: not executed, package body does not exist

 


@dkao wrote:

Used MTK to migrate a schema from a Oracle database, but then noticed in the target EDB schema the stored package ported only contains the package spect but no package body.  Try to run it will result in:

"ERROR:  not executed, package body does not exist".  Did I miss anything when I ran runMTK.sh ?


Hi dkao,

 

Thanks for your inquiry.  To start off, could you share more details about how you ran MTK?  What arguments did you pass in?

 

Cheers,

--Richard

Highlighted
Adventurer

Re: Package ported from Oracle - ERROR: not executed, package body does not exist

I found the problem, the packages and stored procedures I expected all failed the the following error when trying to load them into Postgres schema:

MTK-16006: Error Creating Procedures: PRC_ADD_ISO_METADATA_RECORD
DB-42601: ERROR: unterminated dollar-quoted string at or near "$$PLSQL_UNIT

--

I guess we use $$PLSQL_UNIT  in our current Oracle schma, and that's we should probably avoid before trying to bring them into EDB.  Any way we can map/substitute cretain string dynamically when we run MTK?

About Uber: ======== Uber is a taxi provider like Ola, TaxiForSure etc., which operates in the following Indian cities: - AHMEDABAD - BANGALORE - CHENNAI - H...
Highlighted
Moderator

Re: Package ported from Oracle - ERROR: not executed, package body does not exist


@dkao wrote:

I guess we use $$PLSQL_UNIT  in our current Oracle schma, and that's we should probably avoid before trying to bring them into EDB.  Any way we can map/substitute cretain string dynamically when we run MTK?


At the moment, there doesn't seem to be a way for us to support this, but you may wish to use the PG_CONTEXT variable:

 

https://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-CALL-STACK

 

We do have a feature request open for supporting this syntax, and will likely be out in a near-future version of EDB Postgres Advanced Server

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks