Yes, I should have stated that my assumption was that the user was already logged in on the DB server (by whatever means) and this is tied to the user on the networked server. However, for a local system, no password is required to be passed to Oracle. See here:
in reply to Re^8: DBI Password connection to Oracle
in thread DBI Password connection to Oracle
the idea is to make it so you don't have an oracle password at all. you log
into the OS and the database trusts you are who the OS says you are.
Granted it's all theory at this point (and trusting the documentation) and it's not documented on how to do this over a network - that part is pure speculation.
What isn't speculation is that this is more an Oracle question than a Perl question and that Oracle has many ways to do this on its own :)