How are Microsoft SQL Server and Sybase Adaptive Server EXEC statements parsed?
The Migration Workbench assumes that SQL statements, such as EXEC (exec_string) are dynamic SQL and are sent to an EXEC_SQL PL/SQL stored procedure for execution. Because the contents of the exec_string string are not parsed, you might need to manually edit this string. Other EXEC statements such as EXEC (exec_string) are converted to PL/SQL procedure calls.
Related Questions
- What is the equivalent of the Microsoft SQL Server or Sybase Adaptive Server SYSOBJECTS table in an Oracle database?
- What is the Microsoft SQL Server or Sybase Adaptive Server DATETIME data type mapped to within an Oracle database?
- How are Microsoft SQL Server and Sybase Adaptive Server EXEC statements parsed?