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.
