db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mano (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 05:49:22 GMT

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

Mano commented on DERBY-2859:

I am using 10.2 version. I am having the same issue. i have been working around with issue
from quit a time now. 
Let me add my add my code and error here. It might give you proper idea.
Any help is really appreciated. Thanks.

java.sql.PreparedStatement statement = connect.prepareStatement("CALL    SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE(?,?,?,?,?,?,?)");
statement.setString(1, null);
statement.setString(2, "xyz");
statement.setString(3, "c:/derbytest/xyz.csv");
statement.setString(4, null);
statement.setString(5, null);
statement.setString(6, null);
statement.setString(7, "c:/derbytest/xyz.dat");


Here is the error: Caused by: org.apache.derby.client.am.SqlException: 'SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE'
is not recognized as a function or procedure. at org.apache.derby.client.am.Statement.completeSqlca(Unknown
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source) 
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readPrepare(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepare(Unknown Source) 
at org.apache.derby.client.net.NetStatement.readPrepare_(Unknown Source) 
at org.apache.derby.client.am.Statement.readPrepare(Unknown Source) 
at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInput(Unknown Source) at
org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source) at org.apache.derby.client.am.Connection.prepareStatementX(Unknown
Source) ... 3 more

> 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:
>            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:
> (
>   'select * from lobtable where updateCount in( 2, 4 )',
>   '/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

View raw message