Error caling Postgresql function with devart linqtopostgres

Error caling Postgresql function with devart linqtopostgres

Postby alfrye » Fri 11 Jun 2010 17:43

I have a postgresql function that returns type record. The function has 2 input parameters and 4 output parameters. When I run the linq code to execute the function I get error code 42883
Hint "No function matches the given name and argument types. You might need to add explicit type casts."
Message : Message "function schema_2.get_hmidiagrams(unknown, unknown, unknown, unknown, unknown, unknown) does not exist"
alfrye
 
Posts: 16
Joined: Wed 05 May 2010 19:39

Postby AndreyR » Mon 14 Jun 2010 14:05

Could you please send us (support * devart * com, subject "LINQ: Sp in PostgreSQL") the script of the procedure you encounter the problem with?
We will investigate the situation.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby alfrye » Mon 14 Jun 2010 14:11

CREATE OR REPLACE FUNCTION schema_2.get_diagrams_test(IN diagid integer, OUT diagramname character varying, OUT diagramcontents text, OUT description character varying, OUT diagramtype character varying)
RETURNS record AS
$BODY$
DECLARE
r record;
Begin
SELECT d.DiagramName,d.DiagramContents,d.description,dt.diagramtype
into r
from
schema_2.Diagrams d
inner join schema_2.diagramtype dt on d.diagramtype = dt.typeid
where
d.diagramid=diagid;
IF NOT FOUND THEN
RAISE EXCEPTION 'Diagram does not exists,DNFE';
END IF;
diagramName:= r.diagramname;
diagramContents:=r.DiagramContents;
description:=r.description;
diagramType:=r.diagramtype;

End;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
alfrye
 
Posts: 16
Joined: Wed 05 May 2010 19:39

Postby AndreyR » Tue 15 Jun 2010 16:34

I have tried to create a similar function using the latest 4.95.140 build and succeeded. Are you using the latest build?
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby alfrye » Tue 15 Jun 2010 19:36

After updating to 4.95 I am able to get my issued resolved.

I am licensed copy of dot connect is there anything I need to do to upgrade to the latest version.

Thanks for your support!
alfrye
 
Posts: 16
Joined: Wed 05 May 2010 19:39

Postby AndreyR » Wed 16 Jun 2010 10:35

Go to Registered Users' Area. In case you have the wrong version please contact our sales (sales * devart * com).
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for PostgreSQL