Calling JAVA method to connect Database through JDBC URL from PLSQL by Pranay Tiwari
Recently I got a requirement in my project to form a connection with the different database servers and fetch data to display for further processing. To accomplish this requirement we have registered PLSQL package as a java source. You can find more details on the below link https://docs.oracle.com/en/database/oracle/oracle-database/18/jjdev/calling-Java-from-PL-SQL.html#GUID-499ABE6B-4391-43C8-A527-74A6C7B0A0FF Registering PLSQL package as java source to form database connection JDBC. CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "pocJavaTest" AS import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class pocJavaTest { public static String world() { String s1=""; String driver = "oracle.jdbc.driver.OracleDriver"; String SQLSTMT = "SELECT OWNER,OBJECT_NAME,