[
https://issues.apache.org/jira/browse/DERBY-5945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13556028#comment-13556028
]
Holger Rehn commented on DERBY-5945:
------------------------------------
Thanks for your fast reply. To reproduce the problem, simply execute the
following few lines of code:
Class.forName( "org.apache.derby.jdbc.EmbeddedDriver" );
Connection conn = DriverManager.getConnection(
"jdbc:derby:db;create=true", "user", "pwd" );
Statement sta = conn.createStatement();
try
{
sta.executeUpdate( "drop procedure \"PROC\"" );
}
catch( Exception e )
{
// ignore, PROC doesn't exist when run for the first time
}
sta.execute( "create procedure PROC( inout x int ) parameter style java
modifies sql data language java external name 'DUMMY.PROC'" );
sta.execute( "{call PROC(1)}" );
Please note, that there is only one parameter of type INOUT and the parameter
value is provided directly.
Beside the NPE thing, your fix to the original bug seems to work well. Should I
close this ticket then or would you prefer to keep it open until you had a look
into the NPE problem which didn't occur before?
Cheers,
momo
> Inappropriate error message when calling a procedure as a function (as if it
> had a return value)
> ------------------------------------------------------------------------------------------------
>
> Key: DERBY-5945
> URL: https://issues.apache.org/jira/browse/DERBY-5945
> Project: Derby
> Issue Type: Improvement
> Components: JDBC, SQL
> Reporter: Holger Rehn
> Assignee: Dag H. Wanvik
> Priority: Minor
> Fix For: 10.10.0.0
>
> Attachments: derby-2927-5945-diag-2.diff,
> derby-2927-5945-diag-2.stat, derby-2927-5945-diag-3.diff,
> derby-2927-5945-diag-3.stat, derby-2927-5945-diag.diff,
> derby-2927-5945-diag.stat, derby-5945.diff, derby-5945.stat
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
