db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Holger Rehn (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5945) Inappropriate error message when calling an existing procedure with non-matching parameters
Date Thu, 11 Oct 2012 18:11:03 GMT

    [ 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

Mime
View raw message