Bug 217321

Description Adrian Pang 2008-01-31 14:43:28 EST

Build ID: I20071213-1700

Steps To Reproduce:
1.On a MS SQL Server 2005 system, create a stored procedure in a database:

ALTER PROCEDURE [dbo].[testFunction]
AS
BEGIN
	SET NOCOUNT ON;
	SELECT * from testTable
END
2. run the stored procedure; it runs fine and return the data in the table "testTable"
3. create a connection profile and connect to the sql server, and navigate to the "Stored Procedures" node.  The function is shown.
4. Right-click on the function and select "Run..."  It will fail with the error:

call testDB.dbo.testFunction
The value is not set for the parameter number 1.

5. right click on the function and select "Edit...".  This is the code:

CREATE PROCEDURE testFunction (
		IN @RETURN_VALUE INTEGER)
	NOT DETERMINISTIC
	NO_SQL

which is different from the definition of the function

More information:
The MS JDBC driver for SQL Server 2005 is used.