Community
Participate
Working Groups
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.
This would be an issue with the SQL Server support in Enablement. Currently we have basic SQL Server support, but that's all. We welcome help further developing this area.