AnsweredAssumed Answered

Setting Version of Oracle Query Layer

Question asked by jungjr11 on Oct 14, 2015
Latest reply on Oct 15, 2015 by jungjr11

I am looking for a way to set the version that a tables versioned view uses when referenced inside ArcMap 10.3 with a query layer. In sql I can use the following to return records only visible to the version specified in line 1.

 

EXEC sde.version_util.set_current_version('user.version_name');
select * from user.sometable_evw;

 

When a query layer is added into ArcMap, the table of contents shows it as referencing the version set in the sde connection file.  In my testing I have found that even though the layer falls under the version you may want, it is only reading rows referenced in the default version.

 

Does anyone know if there is another way to set the version the view is using?

 

Thanks,

 

Joe

Outcomes