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] [Commented] (DERBY-2859) Misleading error message if you supply too many arguments to SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
Date Tue, 19 Nov 2013 13:27:22 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13826485#comment-13826485
] 

Rick Hillegas commented on DERBY-2859:
--------------------------------------

Hi Mano,

This procedure was added to Derby in release 10.3.1.4 by DERBY-378. See https://svn.apache.org/viewvc/db/derby/code/tags/10.3.1.4/RELEASE-NOTES.html?view=co
. Thanks-Rick

> 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.4
>            Reporter: Rick Hillegas
>            Priority: Minor
>              Labels: derby_triage10_5_2
>
> 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 was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message