Stored procedues INOUT parameter

Stored procedues INOUT parameter

Postby » Wed 07 Dec 2011 04:26

i have a stored procedure that has an INOUT parameter. When i try to associate the class with the stored procedure for insert and updates, it does not display the procedure in the "stored procedure" drop down list using the configure behaivour in visual studio.

It only shows stored procedures that have IN parameters

I'm using the devart entity model for postgresql.

Please advice.

Signature of the stored procedure is

CREATE OR REPLACE FUNCTION cbill.insert_attribute_transactions(INOUT p_id integer, IN p_object_id character varying, IN p_attribute_name character varying, IN p_attribute_type character varying)
RETURNS integer AS

Please advice
Posts: 15
Joined: Sat 26 Nov 2011 00:56

Postby » Wed 07 Dec 2011 07:31

I tried setting concealed function = true however it gives me the error

The parameter p_id is bound multiple times. This is because p_id is an INOUT parameter and hence had to be mapped in the input parameter as well as the result set bindings
Posts: 15
Joined: Sat 26 Nov 2011 00:56

Postby Shalex » Wed 07 Dec 2011 16:47

Entity Framework allows to map only IN parameters of stored procedure to class properties. The OUT (INOUT) parameter can be used only for Rows Affected Parameter.
Devart Team
Posts: 7660
Joined: Thu 14 Aug 2008 12:44

Postby » Wed 07 Dec 2011 21:42

ok thanks
Posts: 15
Joined: Sat 26 Nov 2011 00:56

Return to dotConnect for PostgreSQL