Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot Translate>Unknown Object:unexpected end of subtree: Line 0 Column 0

593859Nov 2 2007 — edited Nov 12 2007

I'm currently migrating from:
Microsoft SQL Server 2000 - 8.00.2175 (Intel X86) Dec 1 2005 12:53:33 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0

and running Oracle SQL Developer 1.2.1.3213

While generating the Oracle SQL I get the message in the migration log for 1 stored procedure: "Stored Procedure 'procedure name' has language id of 'MSTSQL' so will not output for generation".

I get the following error while trying to run that same SQL Server stored procedure through the Translation Scratch Editor:
"Cannot Translate > Unknown Object:unexpected end of subtree: Line 0 Column 0"

I've removed all blank lines and comments at the beginning and end of the stored procedure but still get the same errror.

Over 100 stored procedures converted with no errors.

Is there anything else I can try or is this a bug?

Thanks
Ron Becker

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 10 2007

Added on Nov 2 2007

#database-and-application-migrations

1 comment

2,040 views