Examples with PLSQLrecord org.eclipse.persistence.platform.database.oracle.plsql.PLSQLrecord used on opensource projects

Example 6 with PLSQLrecord

use of org.eclipse.persistence.platform.database.oracle.plsql.PLSQLrecord in project eclipselink by eclipse-ee4j.

the class PLSQLProject method buildEmployeeInOutQuery.

protected DatabaseQuery buildEmployeeInOutQuery() {
    PLSQLrecord record = buildEmployeeRecord();
    PLSQLStoredProcedureCall call = new PLSQLStoredProcedureCall();
    call.setProcedureName("PLSQL_P.PLSQL_EMP_INOUT");
    call.addNamedInOutputArgument("P_EMP", record);
    call.addNamedInOutputArgument("P_CITY", JDBCTypes.VARCHAR_TYPE);
    DataReadQuery query = new DataReadQuery();
    query.addArgument("P_EMP", Employee.class);
    query.addArgument("P_CITY", String.class);
    query.setCall(call);
    return query;
}

Example 7 with PLSQLrecord

use of org.eclipse.persistence.platform.database.oracle.plsql.PLSQLrecord in project eclipselink by eclipse-ee4j.

the class PLSQLProject method buildAddressInObjectQuery.

protected DatabaseQuery buildAddressInObjectQuery() {
    PLSQLrecord record = buildAddressRowTypeRecord();
    PLSQLStoredProcedureCall call = new PLSQLStoredProcedureCall();
    call.setProcedureName("PLSQL_ADDRESS_IN");
    call.addNamedArgument("P_ADDRESS", record);
    DataModifyQuery query = new DataModifyQuery();
    query.addArgument("P_ADDRESS", Address.class);
    query.setCall(call);
    return query;
}

Example 8 with PLSQLrecord

use of org.eclipse.persistence.platform.database.oracle.plsql.PLSQLrecord in project eclipselink by eclipse-ee4j.

the class PLSQLProject method buildAddressOutObjectFuncQuery.

protected DatabaseQuery buildAddressOutObjectFuncQuery() {
    PLSQLrecord record = buildAddressRowTypeRecord();
    PLSQLStoredFunctionCall call = new PLSQLStoredFunctionCall(record);
    call.setProcedureName("PLSQL_ADDRESS_OUT_FUNC");
    DataReadQuery query = new DataReadQuery();
    query.setCall(call);
    return query;
}

Example 9 with PLSQLrecord

use of org.eclipse.persistence.platform.database.oracle.plsql.PLSQLrecord in project eclipselink by eclipse-ee4j.

the class PLSQLProject method buildEmployeeOutQuery.

protected DatabaseQuery buildEmployeeOutQuery() {
    PLSQLrecord record = buildEmployeeRecord();
    PLSQLStoredProcedureCall call = new PLSQLStoredProcedureCall();
    call.setProcedureName("PLSQL_P.PLSQL_EMP_OUT");
    call.addNamedOutputArgument("P_EMP", record);
    call.addNamedOutputArgument("P_CITY", JDBCTypes.VARCHAR_TYPE);
    DataReadQuery query = new DataReadQuery();
    query.setCall(call);
    return query;
}

Example 10 with PLSQLrecord

use of org.eclipse.persistence.platform.database.oracle.plsql.PLSQLrecord in project eclipselink by eclipse-ee4j.

the class PLSQLProject method buildEmployeeListInOutQuery.

protected DatabaseQuery buildEmployeeListInOutQuery() {
    PLSQLrecord record = buildEmployeeRecord();
    PLSQLCollection collection = new PLSQLCollection();
    collection.setTypeName("PLSQL_P.PLSQL_EMP_LIST");
    collection.setCompatibleType("PLSQL_P_PLSQL_EMP_LIST");
    collection.setNestedType(record);
    PLSQLStoredProcedureCall call = new PLSQLStoredProcedureCall();
    call.setProcedureName("PLSQL_P.PLSQL_EMP_LIST_INOUT");
    call.addNamedInOutputArgument("P_EMP_LIST", collection);
    call.addNamedInOutputArgument("P_CITY", JDBCTypes.VARCHAR_TYPE);
    DataReadQuery query = new DataReadQuery();
    query.addArgument("P_EMP_LIST", java.sql.Array.class);
    query.addArgument("P_CITY", String.class);
    query.setCall(call);
    return query;
}