db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2859) Misleading error message if you supply too many arguments to SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
Date Fri, 22 Jun 2007 14:36:27 GMT
Misleading error message if you supply too many arguments to SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
----------------------------------------------------------------------------------------------------------

                 Key: DERBY-2859
                 URL: https://issues.apache.org/jira/browse/DERBY-2859
             Project: Derby
          Issue Type: Bug
          Components: SQL, Tools
    Affects Versions: 10.3.1.0
            Reporter: Rick Hillegas


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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message