Executing Java programs from PL/SQL
Similar to C programs, Oracle can communicate with Java classes as external procedures, too. Unlike C external programs, the Java classes and Java source files are stored as schema objects in the database. But the caveat here is that the Java classes must be operational in the logical side and not on the user interface. It implies that the Java programs which offer generic utility or data processing operations are the best candidates to be loaded into Oracle.
Invoking Java code from PL/SQL not only reduces the network overhead from the client but it also helps in the distribution of logic across the layers and reduces code redundancy. Under this section, we will discuss how to load a Java class into the database ...
Get Oracle Advanced PL/SQL Developer Professional Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
