DBI is very solid and heavily used in many business applications. There is support for tons of different databases, including Oracle.

The advantage of using DBI is that since the DBI interface is identical for each database that it supports, you are free to migrate your data from one database to another without having to modify your perl code that accesses it. All you need to do is update the code to use a different driver.

Yeah, sometimes you have to make changes to your code because of new database limitations, but migration issues are very seldom related to the DBI.