Oracle allows you to define a synonym for a database object. For example, an Oracle database might have a table called NY_CUSTOMER with a synonym CUSTOMER. Applications can refer to the table as CUSTOMER. Using synonyms in applications results in generic, more maintainable code. The DataServer supports Oracle synonyms for these objects:

  • Tables
  • Views
  • Sequences
  • Buffers
  • Functions
  • Stored procedures
  • Packages

The DataServer does not support synonyms that point to other synonyms.

Your OpenEdge DataServer applications can reference Oracle objects by their defined synonyms. The DataServer supports synonyms by allowing you to include them when you build the schema image for an Oracle database.

Note: If you use a synonym for a table that has a PROGRESS_RECID column, you must also define a synonym for the corresponding sequence generator and include the synonym in the schema image. For example, if the customer table includes customer_SEQ and you define a synonym, CUST, you must also define and include in the schema image a synonym for the sequence generator, such as CUST_SEQ.