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

Allow functions/procedures to take Blob/Clob arguments

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.4.2.0
    • 10.7.1.1
    • SQL
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: