Fwd: DBD::Oracle Schema different than User question

2012-11-12 Thread Martin J. Evans
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 wh

Re: DBD::Oracle Schema different than User question

2012-11-12 Thread Matthew Musgrove
I've never had a need to have it set in the connect string because our logon trigger sets it for us based on a variety of criteria. execute immediate 'ALTER SESSION SET CURRENT_SCHEMA = SOMESCHEMA'; Matt On Mon, Nov 12, 2012 at 1:04 PM, Martin J. Evans wrote: > Hi Kevin, > > I've forward

RE: DBD::Oracle Schema different than User question

2012-11-12 Thread John Scoles
> Date: Mon, 12 Nov 2012 19:04:56 + > From: martin.ev...@easysoft.com > To: dbi-users@perl.org > CC: kevin.k...@gmail.com > Subject: Fwd: DBD::Oracle Schema different than User question > > Hi Kevin, > > I've forwarded your email on to the dbi-users li

Re: DBD::Oracle Schema different than User question

2012-11-12 Thread Furst, Carl
Switching schemas in Oracle makes no sense, because schemas are tied to the user. In fact you don't login to oracle with a username but with a schema name. Schema and username are the same things. It is not like MySQL where you have Databases that denote these object groups and are separate from us