FUNCTION New
RETURN Ora_java.Jobject
IS
BEGIN
  cls := jni.Get_Class('com/optiosoftware/ecompresent/oracle/wf/OracleECPWebService');
  
  Mid := jni.Get_Method(False,cls,'<init>','()V');
  
  args := NULL;
  
  RETURN (jni.New_Object(cls,Mid,args));
END;

PROCEDURE GetContent
IS
  RaisedException  Ora_java.Jobject;
  Data_Type        Ora_java.Jobject;
  Content_Data     Ora_java.Jobject;
  num              PLS_INTEGER := 2;
  reTval           Ora_java.Jobject;
BEGIN
  Data_Type := OracleecpWebService.New;
  
  Content_Data := OracleecpWebService.New;
  
  reTval := OracleecpWebService.QueryContent(Data_Type,Content_Data,num);
EXCEPTION
  WHEN Ora_java.java_Error THEN
    Message('Unable to call out to Java, '
            ||Ora_java.Last_Error);
    
    Ora_java.Clear_Exception;
  WHEN Ora_java.Exception_Thrown THEN
    RaisedException := Ora_java.Last_Exception;
    
    Message('Java Exception : '
            ||Exception_.GetMessage(RaisedException));
    
    Ora_java.Clear_Exception;
END;

declare
  Data_Type         Ora_java.Jobject;
BEGIN
  dbms_output.put_line ('start');
  Data_Type     := OracleecpWebService.New;
  dbms_output.put_line ('end');
END;

ORA-06550: line 2, column 21:
PLS-00201: identifier 'ORA_JAVA.JOBJECT' must be declared
ORA-06550: line 2, column 21:
PL/SQL: Item ignored
ORA-06550: line 5, column 3:
PLS-00320: the declaration of the type of this expression is incomplete or malfo
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored

public Vector GetPIValue(String TagName, String ReadingTime) throws Exception
.
.
Vector requestBodyEntries = new Vector();

    requestBodyEntries.addElement(TagName);
    requestBodyEntries.addElement(ReadingTime);

public Vector GetPIValue(Elements requesteElement) throws Exception
.
.
Vector requestBodyEntries = new Vector();

    requestBodyEntries.addElement(requesteElement);

FUNCTION GetPIValue(
    obj   ORA_JAVA.JOBJECT,
    a0    VARCHAR2,
    a1    VARCHAR2) RETURN ORA_JAVA.JOBJECT IS
  BEGIN
    Message('param passed: '||a0||' - '||a1);
    cls := JNI.GET_CLASS('oracle/forms/demos/webservice/ConnectToPIStub');
    mid := JNI.GET_METHOD(FALSE, cls, 'GetPIValue', '(Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector;');
    args := JNI.CREATE_ARG_LIST(2);
    JNI.ADD_STRING_ARG(args, a0);
    JNI.ADD_STRING_ARG(args, a1);
    Message('I am Here');
    RETURN JNI.CALL_OBJECT_METHOD(obj, mid, args); 
  END;

Element.setAttribute(param_1,
    'attribName',
    'attribValue');

PROCEDURE setAttribute(
    obj   ORA_JAVA.JOBJECT,
    a0    VARCHAR2,
    a1    VARCHAR2) IS
  BEGIN
    cls := JNI.GET_CLASS('org/w3c/dom/Element');
    mid := JNI.GET_METHOD(FALSE, cls, 'setAttribute', '(Ljava/lang/String;Ljava/lang/String;)V');
    args := JNI.CREATE_ARG_LIST(2);
    JNI.ADD_STRING_ARG(args, a0);
    JNI.ADD_STRING_ARG(args, a1);
    JNI.CALL_VOID_METHOD(obj, mid, args); 
  END;

package project1.proxy;

import oracle.webservices.transport.ClientTransport;
import oracle.webservices.OracleStub;
import javax.xml.rpc.ServiceFactory;
import javax.xml.rpc.Stub;

public class Service1SoapClient {
    private project1.proxy.Service1Soap _port;
    
    public Service1SoapClient() throws Exception {
        ServiceFactory factory = ServiceFactory.newInstance();
        _port = ((project1.proxy.Service1)factory.loadService(project1.proxy.Service1.class)).getService1Soap();
    }
    
    /**
     * @param args
     */
    public static void main(String[] args) {
        try {
            project1.proxy.Service1SoapClient myPort = new project1.proxy.Service1SoapClient();
            System.out.println("calling " + myPort.getEndpoint());
            // Add your own code here
        
             double testResponse = myPort.getPIValue("A3LI004.pv", "9/9/2007 9:20 am");
            System.out.println("response from PI " + testResponse);
        
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    
    /**
     * delegate all operations to the underlying implementation class.
     */
    
    /**
    Connect to PI Server

    **/
    public void connect() throws java.rmi.RemoteException {
        _port.connect();
    }
    
    /**
    Disconnect from PI Server

    **/
    public void disconnect() throws java.rmi.RemoteException {
        _port.disconnect();
    }
    
    /**
    Retrieve PI Values

    **/
    public double getPIValue(String piTAG, String piTS) throws java.rmi.RemoteException {
        return _port.getPIValue(piTAG, piTS);
    }