Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » OUTPUT parameters represented as INOUT for SQL Stored Procedures.
OUTPUT parameters represented as INOUT for SQL Stored Procedures. [message #597043] Thu, 21 January 2010 08:18
Ravikanth Somayaji is currently offline Ravikanth Somayaji
Messages: 39
Registered: July 2009
Location: Oxford
Member
Hello,

I have this sql stored procedure
Quote:
> drop procedure "amxbpm"."allElems"
> GO
> CREATE PROCEDURE "allElems" (
> @id int,@outvalue1 VARCHAR(20) OUTPUT,@outvalue2 decimal OUTPUT
> )
> AS
> BEGIN
> select @outvalue1="id"
> FROM "amxbpm"."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 "amxbpm"."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.
Previous Topic:database development perspective not visible
Next Topic:extend result browser?
Goto Forum:
  


Current Time: Tue Sep 02 03:02:44 EDT 2014

Powered by FUDForum. Page generated in 0.19593 seconds