[
https://issues.apache.org/jira/browse/DERBY-5945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13474382#comment-13474382
]
Holger Rehn commented on DERBY-5945:
------------------------------------
When a procedure is created and later called with non-matching parameters
(namely with a return value), Derby raises an error like
'PROC' is not recognized as a function or procedure.
But the procedure exists. If trying to re-create the procedure, Derby correctly
throws an error "PROCEDURE 'PROC' already exists.", and the procedure can be
dropped via "drop procedure PROC".
to reproduce just execute...
"CREATE PROCEDURE PROC( inout ret in ) parameter style java modifies sql data
language java external name 'DBProcs.PROC'"
"{?=call PROC(1)}"
The error message should point out, that either the procedure cannot return a
value or that no matching procedure can be found.
Cheers,
momo
> Inappropriate error message when calling an existing procedure with
> non-matching parameters
> -------------------------------------------------------------------------------------------
>
> Key: DERBY-5945
> URL: https://issues.apache.org/jira/browse/DERBY-5945
> Project: Derby
> Issue Type: Bug
> Reporter: Holger Rehn
>
--
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
