Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » OUTPUT parameters represented as INOUT for SQL Stored Procedures.
icon4.gif  OUTPUT parameters represented as INOUT for SQL Stored Procedures. [message #509129] Thu, 21 January 2010 13:18 Go to next message
Ravikanth Somayaji is currently offline Ravikanth SomayajiFriend
Messages: 39
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

Re: OUTPUT parameters represented as INOUT for SQL Stored Procedures. [message #510180 is a reply to message #509129] Tue, 26 January 2010 15:57 Go to previous message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
Messages: 495
Registered: July 2009
Senior Member
What database are you using? Are you using the Generic JDBC connection
profile or one of the more specific ones customized for a particular DBMS?

Ravikanth wrote:
> 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.
Re: OUTPUT parameters represented as INOUT for SQL Stored Procedures. [message #597094 is a reply to message #509129] Tue, 26 January 2010 15:57 Go to previous message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
Messages: 495
Registered: July 2009
Senior Member
What database are you using? Are you using the Generic JDBC connection
profile or one of the more specific ones customized for a particular DBMS?

Ravikanth wrote:
> 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:extend result browser?
Next Topic:Data Soruce Explorer, No tables, only Schemas visible
Goto Forum:
  


Current Time: Fri Nov 28 07:31:47 GMT 2014

Powered by FUDForum. Page generated in 0.02242 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software