I have no idea how DBD::Oracle is glued together with the Oracle client, maybe it actually uses the Oracle PL*SQL stuff. The important thing is that as long as the client is installed and you're using DBI, you don't really need to know how it actually works because you're using a standard API separating your from all those ugly details.

Still curious? Excellent :-D