Stored procedues INOUT parameter

Stored procedues INOUT parameter

Postby akash.hegde@gmail.com » Wed 07 Dec 2011 04:26

Hi
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
akash.hegde@gmail.com
 
Posts: 15
Joined: Sat 26 Nov 2011 00:56

Postby akash.hegde@gmail.com » 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
akash.hegde@gmail.com
 
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.
Shalex
Devart Team
 
Posts: 7660
Joined: Thu 14 Aug 2008 12:44

Postby akash.hegde@gmail.com » Wed 07 Dec 2011 21:42

ok thanks
akash.hegde@gmail.com
 
Posts: 15
Joined: Sat 26 Nov 2011 00:56


Return to dotConnect for PostgreSQL