How are cross-database procedure calls converted?
Microsoft SQL Server and Sybase Adaptive Server databases are mapped to tablespaces instead of to users. Therefore, procedures in one database that call procedures in another database must be edited after migration. For example, there are two databases called HR and FINANCE, owned by the user SA. There is a procedure called get_sales_employees in the HR database and a procedure called get_quarter_bonuses in the FINANCE database. If get_quarter_bonuses makes a call to get_sales_employees, the syntax is as follows: sa..get_sales_employees The Migration Workbench maps individual databases to separate tablespaces and creates both stored procedures (get_sales_employees and get_quarter_bonuses) under the database owner, which is often SA. Therefore, the previous statement is converted to the following: hr.get_sales_employees In the Oracle Server, the user called SA must own get_sales_employees. See Also: For more information, see “Parsing”.
