title: Access external lib from oracle stored procedures
body: <p>How do we refer to external libraries in oracle stored procedure?</p>
  
  <p>I did this.</p>
  
  <pre><code>loadjava -jarasresource -user apps/xxx@instance sqljdbc.jar
  </code></pre>
  
  <p>(I am loading the lib required for jdbc connection to sql server 2000,)</p>
  
  <p>now, in my oracle stored procedure I want to refer to this lib something like this.</p>
  
  <pre><code>create or replace and resolve java source named SQLConnect as 
  
      import java.sql.*;
      //import com.microsoft.sqlserver.jdbc.SQLServerDriver;
  
     public class SQLConnect {
  
     public static String Test() {
  
      // Create a variable for the connection string.
      //JDBC:SQLSERVER://LOCALHOST:1433;" +"DATABASENAME=ADVENTUREWORKS;INTEGRATEDSECURITY=true;.
      String connectionUrl = "jdbc:sqlserver://222.222.222.22:1433;databaseName=SQLSERVERNAME";
  </code></pre>
  
  <p>Please tell me how this can be done, as right now I am unable to access the library from my stored procedure.</p>