Java and JavaScript in the Database

Hi,

I have one doubt. What are all the advantages and disadvantages of the calling java from PL/SQL?

In actual scenario the java program will be in the Application server side. It will do the operation and it will store the result in Data base. But in this case (calling java from PL/SQL), we are loading the java program in the Data base and it is doing the operations.

I have seen many posts are coming regarding loading jar files into the database. Actually the jar will deploy in to Application server. Is there any difference instead of keeping in the Application server side?

Then I have read,
advantages:
-> java having lot API's. so PL/SQL can use that API's.
-> if we can not do anything in PL/SQL. we can do it using this mtd(calling java from PL/SQL).
My questions:
-> could you explain what are all the things we can not do but we can do using "calling java from PL/SQL" method?
-> is there any other advantages?

Disadvantages:
-> the performance is very slow in calling java from PL/SQL.
My questions:
-> Then why others are loading java files and jar files into database?
-> is there any other disadvantages?

Could you explain about this one? It will be more helpful to others also…

Regards,
kk