Re^2: Connecting to an instance after spliting it with a regexe

[jo5621]

Thanks for pointing me to the right direction, actually what I wanted to do was your first hint and about how do i encrypt passwords? I do that running the environment variable on the code (a code I didn't write) , connecting into the DB it's next thing I wan to figure out, now that I already get the password through command sqlplus from unix with format "user/pass@instance"

 {
        my $output = `~/prod/alert/bin/Enc3DesUtils DEC $2`;
        print "$output\n";
        }

[Anonymous Monk]

To connect to a database what you'll need is DBI and the appropriate driver, which in your case I'm assuming is DBD::Oracle. There are plenty of tutorials online about DBI, here's something from an O'Reilly book (might be a little dated). It seems to me that in your case DBI is probably the way to go. For more advanced database access and ORM, see DBIx::Class.