This is a discussion on Data migration problems in sqldeveloper within the Oracle Miscellaneous forums, part of the Oracle Database category; --> Hi, I am trying to migrate the database from SQL Server environment to Oracle 10g database. I am using ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi, I am trying to migrate the database from SQL Server environment to Oracle 10g database. I am using SQL developer for the same. On converting the captured model to oracle model , i am getting lots of migration errors and that is mostly in the stored procedures . The general error is something like this : Stored Procedure 'usp_CONTMGTDWRCreateDWR' has language id of 'MSTSQL' so will not output for generation . And when i copy the MS-SQl code in the scratch editor and press the translate button , i am predominantly getting these two errors : 1) cannot translate null 2)cannot translate > Unknown object : unxepected end of tree : Line 0 Column 0 Can anyone tell me what do these errors mean and how can i go about correcting them?? Thanks in advance. Shishir. |