I hope that this forum is being monitored actively. We are trying to migrate from Oracle10G to DB2 ESE 9.7.5 using IBM Data Movement Tools. All tables, sequences, views, synonyms and non PL/SQL object can be extracted and deployed. However when we try to deploy PL/SQL objects e.g triggers, functions, procedures and packages we hit either SQLCODE: -4499 ( or SQLCODE: -4470. This is deployed via Interactive Deploy tab.
Usually after a -4499 error has been hit, the connection is closed so subsequent objects deployment will return -4470.
We use Oracle packages heavily in our applications. In our Oracle packages, the "TYPE as Object" declaration are being used; it can be extracted, but the deployment failed. All triggers, functions, procedures and packages seem to be a fail deployment.
The attached screenshot is an example of our trigger being deployed and returned the mention error.
We use IDMT version 2.00-b2114.
The IDMT tool doesn't show any syntax error in the PL/SQL code and quick Googling on SQLCODE: -4499 / SQLCODE: -4470 doesn't help much.
What did we do wrong? And how can a PL/SQL objects extracted using IDMT be deployed into DB2?
Appreciate your replies...
This topic has been locked.
2 replies Latest Post - 2011-11-24T06:45:51Z by [re-arrange]
Pinned topic IDMT Error SQLCODE -4499 when deploying PL/SQL objects
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-11-24T06:45:51Z at 2011-11-24T06:45:51Z by [re-arrange]
SystemAdmin 110000D4XK708 PostsACCEPTED ANSWER
Re: IDMT Error SQLCODE -4499 when deploying PL/SQL objects2011-11-23T15:43:02Z in response to [re-arrange]When you right click on the line (which shows the error in bottom right hand pane), click on the get error message and that will show the detailed error message.
[re-arrange] 2700047ER02 PostsACCEPTED ANSWER
Re: IDMT Error SQLCODE -4499 when deploying PL/SQL objects2011-11-24T06:45:51Z in response to SystemAdminThat doesn't helped either. Here's the detailed error message printed when I right-click:
SQL Error Code = -4499
Object Type = FUNCTION
Object Name = JAZZ_CUSTOM_HASH
Schema = ICBA10
Line Num = -1
This is quite a weird error...