缺失索引:2

Question

我试图从我的ADF应用程序中调用一个SQL过程。

我的AppModule中有以下代码：

public void callProcedureSimulateFromDB(String idCategoria) {
    CallableStatement cs = null;
    System.out.println("categoria-> " + idCategoria);
try {
    cs = getDBTransaction().createCallableStatement("begin ? := SPSIMULATE(?); end;", 0);

    cs.setString(2, idCategoria);
    cs.execute();

} catch (SQLException e) {
    throw new JboException(e);

} finally {
            if (cs != null) {
                try {
                    cs.close();
                }catch (SQLException e) {}
            }
        }
}

在我的后台bean中，我调用了前面的方法：

public String simulate() {
    String categoria = catIdId.getValue().toString();
    if (categoria != null && !categoria.isEmpty()) {
        FacesContext facesContext = FacesContext.getCurrentInstance();
        Application app = facesContext.getApplication();
        ExpressionFactory elFactory = app.getExpressionFactory();
        ELContext elContext = facesContext.getELContext();
        ValueExpression valueExp = elFactory.createValueExpression(elContext, "#{bindings}", Object.class);
        oracle.binding.BindingContainer binding = (oracle.binding.BindingContainer)valueExp.getValue(elContext);
        OperationBinding operationBinding = binding.getOperationBinding("callProcedureSimulateFromDB");

        // Set the Input parameters to the operation bindings as below
        operationBinding.getParamsMap().put("idCategoria", categoria);

        // Invoke the Application module method
        operationBinding.execute();
        // Get the result from operation bindings
        //Object obj = operationBinding.getResult();
        //System.out.println("obj ----> " + obj);
    }
    //ADFContext.object.applicationModule.myAMMethod() ;
    //chamar funçao da DB
    p55.hide();
    return null;
}

我得到了以下错误：

​

​

我做错了什么？我尝试过更改de callable语句和cs.setString()中的数字。然而，问题依然存在。

编辑:对代码做了一些更改之后，我测试了AppModule并得到了以下错误：

(oracle.jbo.JboException) JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=ORA-06550: line 1, column 7:
PLS-00103: Encountered the symbol "=" when expecting one of the following:

   ( begin case declare exit for goto if loop mod null pragma
   raise return select update while with <an identifier>
   <a double-quoted delimited-identifier> <a bind variable> <<
   continue close current delete fetch lock insert open rollback
   savepoint set sql execute commit forall merge pipe purge
The symbol "<an identifier>" was substituted for "=" to continue.

Answer 1

如果SPSIMULATE是一个存储过程(而不是存储函数)，您可以尝试更改这一行：

 cs = getDBTransaction().createCallableStatement("begin ? := SPSIMULATE(?); end;", 0);

至

  cs = getDBTransaction().createCallableStatement("{call SPSIMULATE(?)}", 0);

并确保您在从bean测试过程之前，从后台bean对其进行标注。较小的步伐总是更快。