[
https://issues.apache.org/jira/browse/DERBY-2859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13826797#comment-13826797
]
Mano commented on DERBY-2859:
-----------------------------
I am still getting the same error. Please take a look. Can you also make sure
my procedure format is correct. I have also tried export_Query, same result.
Please comment. Thanks.
Apache Derby Network Server - 10.3.1.4 - (561794) started and ready to accept
connections on port 1527 at 2013-11-19 18:42:41.965 GMT
Exception in thread "main" java.sql.SQLSyntaxErrorException:
'SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE' is not recognized as a function
or procedure.
at
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown
Source)
at com.pari.db.DerbyConnection.<init>(DerbyConnection.java:95)
at com.pari.db.DerbyConnection.main(DerbyConnection.java:191)
Caused by: org.apache.derby.client.am.SqlException:
'SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE' is not recognized as a function
or procedure.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
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: 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)
