Re: (Fwd) Oracle.pm

Hi dbi-users,

Any luck on the below Q?

Thanks - Gautam

Sent from my iPhone

> On Mar 6, 2017, at 6:59 PM, Gowtham <[email protected]> wrote:
> 
> Hi Ron,
> 
> I did that.
> I have two scenarios here. Both the scenarios have same ($dbh,$dbname,$user,$auth,$attr) values.
> Scenario 1: executed code with ORACLE_HOME set to correct value.
> 
> Scenario 2: executed code with incorrect/wrong ORACLE_HOME env variable.
> 
> - So my code returns undef in the second scenario. I'm trying to understand the execution part inside the subroutine _login to establish the dependency of ORACLE_HOME on DBI connection.
> 
> - Curious to know the definition for _login() as this is subroutine from the same Oracle.pm module and this helps me to make some changes as per my requirement.
> 
> Let me know for any questions.
> 
> Thanks - Gautam
> 
> Sent from my iPhone
> 
>> On Mar 6, 2017, at 6:00 PM, Ron Savage <[email protected]> wrote:
>> 
>> Hi Gautam
>> 
>> You don't need to examine the source code of Oracle.pm. You need to print out the values of ($dbh,$dbname,$user,$auth,$attr) and focus purely on them, and how they differ from what Oracle.pm expects.
>> 
>>> On 07/03/17 10:22, Tim Bunce wrote:
>>> ----- Forwarded message from Gowtham <[email protected]> -----
>>> 
>>> Date: Mon, 6 Mar 2017 15:40:59 -0600
>>> From: Gowtham <[email protected]>
>>> To: [email protected]
>>> Subject: Oracle.pm
>>> 
>>> Hi Tim,
>>> 
>>> I feel that you are the right person to check this with.
>>> 
>>> I am trying to understand the code on Oracle.pm (DBD::Oracle) to debug my perl code which tries to make a connection to an Oracle DB. My code exits on the below piece of code on debug mode and i am unable to establish the reason for it.
>>>  DBD::Oracle::db::_login($dbh,$dbname,$user,$auth,$attr) or return undef;
>>> 
>>> I am unable to find the definition for the subroutine _login() which will help me to understand the reason for returning 'undef'. Could you please kindly advice me.
>>> 
>>> Correct me if i have reached a wrong email.
>>> 
>>> Thanks - Gautam
>>> 
>>> ----- End forwarded message -----
>>> 
>> 
>> -- 
>> Ron Savage - savage.net.au