List of useNamedCursorOutputAsResultSet() Examples

Examples of useNamedCursorOutputAsResultSet()

org.eclipse.persistence.queries.StoredProcedureCall.useNamedCursorOutputAsResultSet()
PUBLIC: Used for Oracle result sets through procedures. This can only be used if the arguments are not named but ordered.

Examples of org.eclipse.persistence.queries.StoredProcedureCall.useNamedCursorOutputAsResultSet()

                }
                else {
                    for (ProcedureOutputArgument arg : getOutArguments()) {
                        // use argument type
                        if (arg.getResultType() != null && isCursorType(xrService, arg.getResultType())) {
                            spCall.useNamedCursorOutputAsResultSet(arg.getName());
                        } else {
                            spCall.addNamedOutputArgument(arg.getName());
                        }
                    }
                }

View Full Code Here

Examples of org.eclipse.persistence.queries.StoredProcedureCall.useNamedCursorOutputAsResultSet()

                    spCall.setReturnsResultSet(true);
                } else {
                    for (ProcedureOutputArgument arg : getOutArguments()) {
                        // use argument type
                        if (arg.getResultType() != null && isCursorType(xrService, arg.getResultType())) {
                            spCall.useNamedCursorOutputAsResultSet(arg.getName());
                        } else {
                            // if the JDBC Type code is set on the argument, use it
                            if (arg.isJdbcTypeSet()) {
                                spCall.addNamedOutputArgument(arg.getName(), arg.getName(), arg.getJdbcType(), getTypeNameForJDBCType(arg.getJdbcType()));
                            } else {

View Full Code Here

Examples of org.eclipse.persistence.queries.StoredProcedureCall.useNamedCursorOutputAsResultSet()

                }
                else {
                    for (ProcedureOutputArgument arg : getOutArguments()) {
                        // use argument type
                        if (arg.getResultType() != null && isCursorType(xrService, arg.getResultType())) {
                            spCall.useNamedCursorOutputAsResultSet(arg.getName());
                        } else {
                            spCall.addNamedOutputArgument(arg.getName());
                        }
                    }
                }

View Full Code Here

Examples of org.eclipse.persistence.queries.StoredProcedureCall.useNamedCursorOutputAsResultSet()

                }
                else {
                    for (ProcedureOutputArgument arg : getOutArguments()) {
                        // use argument type
                        if (arg.getResultType() != null && isCursorType(xrService, arg.getResultType())) {
                            spCall.useNamedCursorOutputAsResultSet(arg.getName());
                        } else {
                            spCall.addNamedOutputArgument(arg.getName());
                        }
                    }
                }

View Full Code Here

Examples of org.eclipse.persistence.queries.StoredProcedureCall.useNamedCursorOutputAsResultSet()

                }
                else {
                    for (ProcedureOutputArgument arg : getOutArguments()) {
                        // use argument type
                        if (arg.getResultType() != null && isCursorType(xrService, arg.getResultType())) {
                            spCall.useNamedCursorOutputAsResultSet(arg.getName());
                        } else {
                            spCall.addNamedOutputArgument(arg.getName());
                        }
                    }
                }

View Full Code Here

Examples of org.eclipse.persistence.queries.StoredProcedureCall.useNamedCursorOutputAsResultSet()

        } else if (mode.equals(ParameterMode.INOUT)) {
            call.addNamedInOutputArgument(parameterName, parameterName, parameterName, type);
        } else if (mode.equals(ParameterMode.REF_CURSOR)) {
            boolean multipleCursors = call.getParameterTypes().contains(call.OUT_CURSOR);
            
            call.useNamedCursorOutputAsResultSet(parameterName);
            
            // There are multiple cursor output parameters, then do not use the 
            // cursor as the result set. This will be set to true in the calls
            // above so we must do the multiple cursor call before hand.
            if (multipleCursors) {

View Full Code Here

Examples of org.eclipse.persistence.queries.StoredProcedureCall.useNamedCursorOutputAsResultSet()

                }
                else {
                    for (ProcedureOutputArgument arg : getOutArguments()) {
                        // use argument type
                        if (arg.getResultType() != null && isCursorType(xrService, arg.getResultType())) {
                            spCall.useNamedCursorOutputAsResultSet(arg.getName());
                        } else {
                            spCall.addNamedOutputArgument(arg.getName());
                        }
                    }
                }

View Full Code Here

Examples of org.eclipse.persistence.queries.StoredProcedureCall.useNamedCursorOutputAsResultSet()

        } else if (mode.equals(ParameterMode.INOUT)) {
            call.addNamedInOutputArgument(parameterName, parameterName, parameterName, type);
        } else if (mode.equals(ParameterMode.REF_CURSOR)) {
            boolean multipleCursors = call.getParameterTypes().contains(call.OUT_CURSOR);
            
            call.useNamedCursorOutputAsResultSet(parameterName);
            
            // There are multiple cursor output parameters, then do not use the 
            // cursor as the result set. This will be set to true in the calls
            // above so we must do the multiple cursor call before hand.
            if (multipleCursors) {

View Full Code Here

Examples of org.eclipse.persistence.queries.StoredProcedureCall.useNamedCursorOutputAsResultSet()

                }
                else {
                    for (ProcedureOutputArgument arg : getOutArguments()) {
                        // use argument type
                        if (arg.getResultType() != null && isCursorType(xrService, arg.getResultType())) {
                            spCall.useNamedCursorOutputAsResultSet(arg.getName());
                        } else {
                            spCall.addNamedOutputArgument(arg.getName());
                        }
                    }
                }

View Full Code Here

Examples of org.eclipse.persistence.queries.StoredProcedureCall.useNamedCursorOutputAsResultSet()

                }
                else {
                    for (ProcedureOutputArgument arg : getOutArguments()) {
                        // use argument type
                        if (arg.getResultType() != null && isCursorType(xrService, arg.getResultType())) {
                            spCall.useNamedCursorOutputAsResultSet(arg.getName());
                        } else {
                            spCall.addNamedOutputArgument(arg.getName());
                        }
                    }
                }

View Full Code Here

0 1

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.