Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4066

Allow functions/procedures to take Blob/Clob arguments

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.4.2.0
    • Fix Version/s: 10.7.1.1
    • Component/s: SQL
    • Labels:
    • Bug behavior facts:
      Deviation from standard

      Description

      Derby objects if you try to declare a function or procedure with an argument whose type is BLOB or CLOB. These kinds of arguments are allowed in the SQL standard and the matching Java types are java.sql.Blob and java.sql.Clob. See the SignatureMatching.html summary attached to DERBY-3652.

      We should lift this restriction and allow functions and procedures to take large object arguments.

        Attachments

        1. derby-4066-01-aa-enableLobArgs.diff
          7 kB
          Richard N. Hillegas
        2. derby-4066-01-ab-enableLobArgs.diff
          13 kB
          Richard N. Hillegas
        3. derby-4066-01-ag-enableLobArgs.diff
          19 kB
          Richard N. Hillegas
        4. derby-4066-01-ak-enableLobArgs.diff
          19 kB
          Richard N. Hillegas
        5. derby-4066-01-al-enableLobArgs.diff
          27 kB
          Richard N. Hillegas
        6. derby-4066-02-ac-outputLOBs.diff
          19 kB
          Richard N. Hillegas
        7. derby-4066-03-aa-bigLOBs.diff
          4 kB
          Richard N. Hillegas
        8. derby-4066-04-aa-testTweak.diff
          2 kB
          Richard N. Hillegas

          Issue Links

            Activity

              People

              • Assignee:
                rhillegas Richard N. Hillegas
                Reporter:
                rhillegas Richard N. Hillegas
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: