DMS: Problem with createStoredProc method of ConsolidatorManager class in Oracle Lite 10.3.0.2.0

 Hi all,

I have a problem with createStoredProc method of ConsolidatorManager class.

Here the testcase to explain the issue :

create table t ( id number(12,0),key varchar2(200));

Create class :

==================JAVA CLASS=============

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Test {
   
    public static String method(Connection con,Long l){
       String key=null;
      
       try {
        String query = "select key from t where id = " + l;
        PreparedStatement stmt = con.prepareStatement(query);
        ResultSet rs=null;
        rs = stmt.executeQuery(query);
        while (rs.next()) {
            key = rs.getString("key");
        }
       } catch (Exception ex){
          
       }
       return key;
    }
}

============END================

compile by javac Test.java

Create class :

===================PUBLISH USING LITE APIS========