Try OpenEdge Now
skip to main content
DataServer for Oracle
Initial Programming Considerations : Database design issues : Oracle views : Multi-table views
 
Multi-table views
The DataServer supports direct access to multi-table views. Use the following ABL syntax to read rows from multi-table views:

Syntax

FOR EACH view-name { NO-LOCK | SHARE-LOCK } :
You cannot use other ABL queries, such as the DEFINE QUERY, OPEN QUERY, GET, and DEFINE BROWSE statements, to access multi-table views.
ABL cannot recognize whether a view in an Oracle database is a multi-table view. Although the DataServer copies multi-table views into the schema image, ABL returns run-time errors if you try to update them with an OpenEdge application.