You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Myrna van Lunteren (JIRA)" <ji...@apache.org> on 2014/03/11 16:33:43 UTC
[jira] [Resolved] (DERBY-6418)
'SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE' is not recognized as a
function or procedure
[ https://issues.apache.org/jira/browse/DERBY-6418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren resolved DERBY-6418.
---------------------------------------
Resolution: Not A Problem
Assignee: Knut Anders Hatlen
> 'SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE' is not recognized as a function or procedure
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-6418
> URL: https://issues.apache.org/jira/browse/DERBY-6418
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Reporter: Mano
> Assignee: Knut Anders Hatlen
> Priority: Blocker
>
> I am using derby database. Using a prepared statement and executing. I dont have problem with non-BLOB field tables. If a table has a blob and trying to export to a file. Then this error comes. Please help me resolve it. I think I am not giving the statement properly. Please guide me. Attaching my code here. Thanks in advance.
> 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");
> statement.executeUpdate();
> statement.close();
> 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 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
--
This message was sent by Atlassian JIRA
(v6.2#6252)