Posts

Showing posts from June, 2020

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 =  ...