Announcement Announcement Module
Collapse
No announcement yet.
SimpleJdbcCall.returningResultSet - parameterName for RETURN from oracle stored func Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • SimpleJdbcCall.returningResultSet - parameterName for RETURN from oracle stored func

    If in PL/SQL I have

    Code:
    FUNCTION stored_function
    RETURN PLSQL_RECORD_TYPES.REF_DATA_CURSOR;
    Then

    Code:
    SimpleJdbcCall foo = bar.returningResultSet("", rowMapper);
    return foo.executeFunction(Collection.class);
    seems to work, but is "" the right thing to use as parameterName here, I should I be using something else?

    (I don't think any other details are relevant, but please let me know)

    Thanks,
    djm

    Edit:
    In the package plsql_record_types:

    Code:
        TYPE ref_data_cursor IS REF CURSOR;
    Last edited by djm; Aug 17th, 2011, 08:38 AM.
Working...
X