Announcement Announcement Module
Collapse
No announcement yet.
How to run a Oracle function with CallableStatementCallback Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to run a Oracle function with CallableStatementCallback

    i want to call an oracle function which takes 5 or 6 input and has a single output. Using the following code,

    CallableStatementCallback cb = new CallableStatementCallback() {
    public Object doInCallableStatement(CallableStatement cs)
    throws SQLException {
    cs.execute();
    return null;
    }
    };

    jdbcTemplate.execute( "{ ? = content_item.new ( ?, ?, ?) }", cb );

    Now my question , How do i define what these input vars are ?
    and how do i get the returned value from this function .

    Thank you
Working...
X