Migration Guide : Upgrading from OpenROAD 6.0 : Phase 2: Convert the Applications : Issuing Table-less Queries Against Enterprise Access
 
Share this page          
Issuing Table-less Queries Against Enterprise Access
Issuing a SELECT query without a FROM clause against Enterprise Access worked with versions of OpenROAD prior to 6.0 but will now fail. For example, the following type of code is a “table-less” query:
sqlString = 'select is_member(''db_owner'')';
Execute Immediate sqlString Into :sqlResult;
To resolve this situation, modify the code so that it contains a FROM clause:
sqlString = 'select is_member(''db_owner'') from iidbconstants';
Execute Immediate sqlString Into :sqlResult;
Issuing table-less queries against Enterprise Access works in OpenROAD 5.1 and prior versions. It does not work in OpenROAD 6.0 or later because those versions convert queries containing string literals into queries without literals, replacing them with bind parameters. Enterprise Access supports table-less queries without bind parameters.
A future release or patch of Enterprise Access will support table-less queries with bind parameters.