238911.1

Oracle Technology Network

Database
Middleware
Developer Tools
Enterprise Management
Applications Technology
Products A-Z

BI & Data Warehousing
Embedded
Java
Linux
.NET
PHP
Security
Windows Server System
Technologies A-Z

Enterprise 2.0
Extreme Transaction Processing
Grid
Service-Oriented Architecture
Virtualization

Join OTN
Oracle ACEs
Oracle Wiki
Blogs
Podcasts
Events
Newsletters
Oracle Magazine
Oracle Books
Certification
User Groups
Partner White Papers

GETTING STARTED

E-mail this page

Purpose
To inform Migration Engineers of the correct procedure for manually editing Dynamic SQL.

Scope & Application
The audience for this document is Oracle Customers, Oracle Partners and Migration Specialists using the Oracle Migration Workbench to migrate SQL Server or Sybase databases.

Manually Migrate Dynamic SQL
Dynamic SQL is not migrated by the Oracle Migration Workbench.Code containing dynamic SQL should be manually edited to enable it to run on Oracle. The most common changes are: Verify there are no SQL Server or Sybase specific constructs inside String literals. Remove all references to dbo in table names Remove all references to Temporary Tables

Before	After Migration(Workbench)	After Manual Change
select@qry ='SELECT col1 from dbo.table1'	proc.qry:= 'SELECT col1 from dbo.table1'	proc.qry:= 'SELECT col1 from table1'

E-mail this page

	About Oracle \| \| Careers \| Contact Us \| Site Maps \| Legal Notices \| Terms of Use \| Privacy