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"
Error caling Postgresql function with devart linqtopostgres
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;
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;
Go to Registered Users' Area. In case you have the wrong version please contact our sales (sales * devart * com).