I read somewhere in documetation that PL/SQL is better for
database-intensive operations, and JSP for logic-intensive operations.
I can tell you what I use JSP for. We have some XML exchange with our
vendors. Every time new order is created, trigger calls JSP that creates XML
and sends it to servlet on Apache/Tomcat server (outside firewall) which
forwards XML to our vendors. With java classes, it's very easy to program
things like that. Possible that it can be done with PL/SQL, but this way
it's easyer.
Right now, I'm planing to connect my oracle with non-oracle database. Since
I'm on UNIX, lack of ODBC driver prevents me from using heterogeneous
connectivity. I'm trying to load JDBC driver for this non-Oracle database,
and connecto to it through JSP.
