Fwd: DBD::Oracle Schema different than User question

Hi Kevin,

I've forwarded your email on to the dbi-users list. See 
http://dbi.perl.org and look at the support page. Sorry for top posting 
but my email client is having some sort of fit with your email. I don't 
have any issue with any well formed patch to set the schema but I'll 
wait to see what others say as personally I've never had to change it.

Martin


-------- Original Message --------
Subject: DBD::Oracle Schema different than User question
Date: Mon, 12 Nov 2012 13:04:05 -0500
From: Kevin L. Kane <[email protected]>
To: Tim Bunce <[email protected]>, Yanick Champoux <[email protected]>,
"Martin J. Evans" <[email protected]>

Hi all,
    I am running into a problem and was planning on modifying my local
DBD::Oracle to add support for a "schema=<mySchema>" construct in the
connect string.  Specifically, I want to connect as user X but set
current_schema to Y.  Another solution i've toyed with is having a
trigger that switches my schema when I log in but I need to do this
for a lot of different schemas and I will always be the same user.  It
seems weird to me that support for this isn't included in DBD::Oracle
currently.

If I do this in a sane way are you at all interested in the patch?  Am
I just missing something and this functionality is already there? Or
should this functionality not exist in the first place and why?

Thanks,
Kevin
-- 
Kevin L. Kane
kevin.kane at gmail.com