[mapserver-users] Oracle Layer: how to set context prior to fetching the data

One of the Oracle based sources we are publishing is using Oracle context variables to enable Oracle's fine grained access control. So we are in the need to set these context variables (e.g. current username) prior to doing the select defined by MapServer's DATA statement. In other applications we

Re: [mapserver-users] Oracle Layer: how to set context prior to fetching the data

Martin, How I've done this in the past is use a plsql function that sets the context and call that function in the query (and just have the function return a dummy value that you don't use). Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers On 3/24/16, 5:59 AM,

Re: [mapserver-users] Oracle Layer: how to set context prior to fetching the data

Hi Martin, Have you tried using a virtual spatial layer (.ovf) file to manage this? You can include a "" tag to run your stored procedure. See examples at http://mapserver.org/input/vector/VirtualSpatialData.html More details of that driver at: http://www.gdal.org/drv_vrt.html Otherwise,

Re: [mapserver-users] Oracle Layer: how to set context prior to fetching the data

The other option is to create yet-another stored procedure wrapper. In the Mapfile, you'd call the special wrapper stored procedure and it would return the rows to map. On Thu, Mar 24, 2016 at 8:16 AM, Jeff McKenna wrote: > Hi Martin, > > Have you tried using a