Re: Put code inside or outside database?

On Sat, 09 Apr 2005 13:43:30 +1000, Tim X interested us by writing:

>
> need to interact with the OS or filesystem. Compare PL/SQL with Java
> or Perl in processing input from a CSV formatted file or generating a
> report etc.

While I agree with many of your comments, I feel this one may be based on history from, say, the Oracle 7.3 or 8.0 days.

You may want to revisit 'External Tables', 'External Procs', the available supplied Java and PL/SQL paackages and Java in the database - then decide whether the comment is still valid.

(And, yes there are occasions when Java and Perl are far superior. Your final comments are bang on.)

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***