in reply to perl array with oracle db name

Add a use warnings; after your use strict. That should help with any oddities caused by your code.

Your tnsentry.txt file could be read into a hash of hashes by the looks of it to me. (See perldsc) You might take a look at some of the CPAN modules that read various text formats. Perhaps one of the Config::* modules. That might save you a bit of time having to write a parser for reading that file in. If nothing else, looking at the POD for a couple of them should give you some good ideas of how to write your own if you want or have to.

Hope that is helpful...

Update:Actually, it looks like DBD::Oracle has the ability to do what you want built right into the module. I have not worked with Oracle, but if your file is like This, the the above module looks like it will do what you want without you having to re-invent the wheel. Again, I have not worked with this, so take this with a grain of salt, or a pound...

...the majority is always wrong, and always the last to know about it...

Insanity: Doing the same thing over and over again and expecting different results...

Replies are listed 'Best First'.
Re^2: perl array with oracle db name
by homer4all (Acolyte) on May 22, 2014 at 19:33 UTC
    Thank you for your reply... I'm able to connect database without any problem... my problem is 1. read tnsentry file (tnsfile.txt) 2. Search for db alias (SID = db1 , SID = db2 etc) 3. Store each db alias temporary into array 4. Use each alias for db connection in $dbConnect function I can read the file but extracting distinct db alias and use them for connection is the challenge for me.

      I did find one more place where someone seems to have been wanting to do what you are also after:

      Here is the code... and here is the originating article...

      Hope that fits the bill a bit better...

      ...the majority is always wrong, and always the last to know about it...

      Insanity: Doing the same thing over and over again and expecting different results...