I do my SQL calls from Java/C++/.NET/etc. Why should I use PL/SQL?
Since PL/SQL and SQL integration is seamless, and they both run on the Oracle server, PL/SQL is generally easier, more efficient, and has more sophisticated built-in capabilities than is available when performing the integration with other languages.
A single call to PL/SQL can run a program with any number of calls toSQL. If each of those calls were made from another language, there would be much more traffic across the network. If you needed 10,000 calls to SQL to accomplish your task, another language would have to place 10,000 calls on the network. If PL/SQL did the work, only one call would be placed on the network: “Run the PL/SQL program”.