Oracle migration problem.

Hello, I have an interesting issue when I migrate my database from Oracle 10 to enterpriseDB.
The database migration tool refuse to migrate the packages that have " ... IS NUMBER ..." in their descriptions.
For example for the package that begins with:

CREATE OR REPLACE PACKAGE Force_to_Finish AS
TYPE t_return IS REF CURSOR;
SUBTYPE t_number IS NUMBER;
...

migration tool says:

Creating Package: FORCE_TO_FINISH
Error Creating Package Spec FORCE_TO_FINISH: ERROR: syntax error at or near "IS" at position 89
; SUBTYPE t_number IS NUMBER
^

Can anyone help me with this problem?
Thanks.

This message was edited 1 time. Last update was at 6 Oct 2009 03:39:36

Currently there is no direct support of SUBTYPE in Package declaration. So, manual migration would be require for such package to PPAS. Also, DOMAIN is a substitute for SUBTYPE in PPAS.

Try the following workaround:

CREATE DOMAIN t_number as number;
CREATE OR REPLACE PACKAGE Force_to_Finish AS
TYPE t_return IS REF CURSOR;
m t_number;
END;

Hi,

I am using Postgres Advanced Server evaluation version.
I have an issue with Oracle migration.. below is the sample Oracle Store Procedure with error genarated by the Migration Studio tool. There are nearly 7000 Procedures out of 50% are used XML CLOB, XML Extraction is used. Suggest me a solution to over come this issue..

XML Stored Procedure:

Creating Procedure: P_UPDATEAGENCYMASTER
Error Creating Procedure P_UPDATEAGENCYMASTER: ERROR: syntax error at or near "(" near line 24
Statement:--Updating the Agency details
UPDATE AgencyMaster
SET NameOfAgency = EXTRACT(XMLTYPE(iv_ExternalAgency),'ExternalAgency/@NameOfAgency').getStringVal(),
NoOfAmbulances = EXTRACT(XMLTYPE(iv_ExternalAgency),'ExternalAgency/@NoOfAmbulances').getNumberVal(),
ContactNumber=EXTRACT(XMLTYPE(iv_ExternalAgency),'ExternalAgency/@ContactNumber').getStringVal(),
ContactPersonName = EXTRACT(XMLTYPE(iv_ExternalAgency),'ExternalAgency/@ContactPersonName').getStringVal(),
Street = EXTRACT(XMLTYPE(iv_ExternalAgency),'ExternalAgency/@Street').getStringVal(),
Locality = EXTRACT(XMLTYPE(iv_ExternalAgency),'ExternalAgency/@Locality').getStringVal(),
City = EXTRACT(XMLTYPE(iv_ExternalAgency),'ExternalAgency/@City').getNumberVal(),
District = EXTRACT(XMLTYPE(iv_ExternalAgency),'ExternalAgency/@District').getNumberVal(),
State = EXTRACT(XMLTYPE(iv_ExternalAgency),'ExternalAgency/@State').getNumberVal(),
Country = EXTRACT(XMLTYPE(iv_ExternalAgency),'ExternalAgency/@Country').getNumberVal(),
PinCode = EXTRACT(XMLTYPE(iv_ExternalAgency),'ExternalAgency/@PinCode').getStringVal(),
AgencyStatus = EXTRACT(XMLTYPE(iv_ExternalAgency),'ExternalAgency/@AgencyStatus').getNumberVal(),
--Extambtype =EXTRACT(XMLTYPE(iv_ExternalAgency),'ExternalAgency/@ExtAmbType').getNumberVal(),
Extambtype=iClob_ExtAmbtype,
Operationalhr =EXTRACT(XMLTYPE(iv_ExternalAgency),'ExternalAgency/@OperationalHr').getNumberVal(),
CreatedBy = iv_LoginID,
CreatedDate = SYSDATE
;
;
;

EXCEPTION
WHEN OTHERS THEN
;*/

;

Error Creating Procedure P_RPTTOTALTIMEETAILS: ERROR: unterminated /* comment at or near "/*//////////////////////////////////////////////////////////////////////////////////