Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Thu, 11 Oct 2012 18:11:03 +0000 (UTC)
From: "Holger Rehn (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <117485379.32433.1349979063359.JavaMail.jiratomcat@arcas>
In-Reply-To: <1603860834.32381.1349978464677.JavaMail.jiratomcat@arcas>
Subject: [jira] [Commented] (DERBY-5945) Inappropriate error message when
 calling an existing procedure with non-matching parameters
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ 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