Devart Forums

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"

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.

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;

I have tried to create a similar function using the latest 4.95.140 build and succeeded. Are you using the latest build?

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!

Go to Registered Users' Area. In case you have the wrong version please contact our sales (sales * devart * com).