Uploaded image for project: 'Spring Framework'
  1. Spring Framework
  2. SPR-10606

SimpleJdbcCall: Function return type (REF CURSOR) should be resolved properly.

    XMLWordPrintable

    Details

      Description

      If you need to call Oracle function like this:

      function get_foo() return ref cursor

      you will get java.sql.SQLException: Invalid column type: 1111

      For regular parameters (not for return type) there is a workaround for ref cursor (see CallMetaDataContext.java:394)

      I have done this also for return type.
      https://github.com/SpringSource/spring-framework/pull/294

        Attachments

          Activity

            People

            Assignee:
            pwebb Phil Webb
            Reporter:
            fuud Fedor Bobin
            Last updater:
            Spring Issuemaster
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              1 year, 25 weeks, 2 days ago