Has anyone out there done anything like this before?

We're investigating here at my company the feasibility of using lightweight sessions i.e. multiple web-based users connecting to the database via a single database user to connect through to 9i Forms and Reports services based on our middle tier server. Those lightweight sessions would then send requests to the database via the forms and reports services without ever being physically connected to the database. It sounds feasible in my mind, but has anyone actually implemented something like this or know of someone who has? What are the pros and cons of such an approach?

Thanks for any help provided!