Perl vs PL/SQL?

I have a perl module I created that interfaces with Oracle via an overengineered here file wrapping a sqlplus session which I keep open, allowing me to continuously send queries to Oracle and retrieve results without having to constantly open and close a sqlplus session (I know about PerlDBI but for administrative reasons we can't install it). I prefer doing it this way becaue of Perl's rich set of language features as compared to PL/SQL.

My question is am I taking a massive performance hit doing this? Is PL/SQL inherently going to be faster then the perl approach? I realize for triggers and such I'll have to stay with PL/SQL but has anyone done a comparison of PL/SQL performance vs other embedded approaches?

Thanks. Received on Mon May 20 2002 - 01:37:37 CDT