OUTPUT parameters represented as INOUT for SQL Stored Procedures. [message #509129] |
Thu, 21 January 2010 13:18 |
Ravikanth Somayaji Messages: 49 Registered: July 2009 Location: Oxford |
Member |
|
|
Hello,
I have this sql stored procedure
Quote: |
drop procedure "mydb"."allElems"
GO
CREATE PROCEDURE "allElems" (
@id int,@outvalue1 VARCHAR(20) OUTPUT,@outvalue2 decimal OUTPUT
)
AS
BEGIN
select @outvalue1="id"
FROM "mydb"."de_humanresource"
return 0;
END
|
when i load it in the Data Sources Explorer and Edit the stored
procedure i end up with this
Quote: |
CREATE PROCEDURE allElems (
IN @RETURN_VALUE INTEGER,
IN @id INTEGER,
INOUT @outvalue1 VARCHAR(20),
INOUT @outvalue2 DECIMAL(18 , 0))
NOT DETERMINISTIC
NO_SQL
BEGIN
select @outvalue1="id"
FROM "mydb"."de_humanresource"
return 0;
END
|
The outcome of which isn't very pleasant. When I use the DTP API to retrieve the Input parameter I get "outValue1" and "outValue2" as input parameters. Now, that isn't what i expect...
Can anyone please advice.
[Updated on: Thu, 21 January 2010 14:32] Report message to a moderator
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04518 seconds