Derby
  1. Derby
  2. DERBY-2859

Misleading error message if you supply too many arguments to SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.3.1.4
    • Fix Version/s: None
    • Component/s: SQL, Tools
    • Urgency:
      Normal
    • Issue & fix info:
      Newcomer, Repro attached

      Description

      If you supply too many arguments to SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE, you get an error message telling you that SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE is an unknown procedure. Instead, you should get an error message which tells you that the signature can't be matched to a known overload of the procedure:

      ij> call SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
      (
      'select * from lobtable where updateCount in( 2, 4 )',
      'LOBTABLE',
      '/export/home/rick/junk/test-export-table1.dat',
      null,
      null,
      null,
      '/export/home/rick/junk/test-export-query1-lobs.dat'
      );
      ERROR 42Y03: 'SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE' is not recognized as a function or procedure.

        Issue Links

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Rick Hillegas
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:

                Development