[DERBY-2859] Misleading error message if you supply too many arguments to SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.3.1.4
• Component/s: SQL, Tools
• Labels: derby_triage10_5_2
• Urgency: Normal
• Issue & fix info: Newcomer, Repro attached
• Assignee: Unassigned
• Reporter: Richard N. Hillegas
• Created: 22/Jun/07 14:35
• Updated: 20/Nov/13 13:28

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

• relates to: DERBY-378 support for import/export of tables with clob/blob and the other binary data types will be good addition to derby,