This question is locked. New answers and comments are not allowed.
Hi,
I have been using OPenAccess with Oracle.
Stored procedures returning a refcursor are working fine.
Now I am beginning to use Postgres, but using refcursor or returning a table allways gives me an error.
Seeking a working example (postgres function + ORM class + Web(Forms/MVC)
Thanks
Zpaulo
I have been using OPenAccess with Oracle.
Stored procedures returning a refcursor are working fine.
Now I am beginning to use Postgres, but using refcursor or returning a table allways gives me an error.
Seeking a working example (postgres function + ORM class + Web(Forms/MVC)
Thanks
Zpaulo
2 Answers, 1 is accepted
0
Jose
Top achievements
Rank 1
Rank 1
answered on 28 Aug 2013, 10:07 AM
Got help from a friend:
- instead of using return cursor
CREATE OR REPLACE FUNCTION f1()
RETURNS refcursor AS
$BODY$
declare
refout refcursor;
begin
open refout for
select col1 , col2 from tab1 ;
return refout;
end;
use
A)
CREATE TYPE ty_1 AS
(col1 integer,
col2 character (1));
B)
CREATE OR REPLACE FUNCTION f1()
RETURNS SETOF ty_1 AS
$BODY$
begin
RETURN QUERY
select col1 , col2 from t1 ;
end;
- instead of using return cursor
CREATE OR REPLACE FUNCTION f1()
RETURNS refcursor AS
$BODY$
declare
refout refcursor;
begin
open refout for
select col1 , col2 from tab1 ;
return refout;
end;
use
A)
CREATE TYPE ty_1 AS
(col1 integer,
col2 character (1));
B)
CREATE OR REPLACE FUNCTION f1()
RETURNS SETOF ty_1 AS
$BODY$
begin
RETURN QUERY
select col1 , col2 from t1 ;
end;
---
On ORM : get function -> domain method -> retrieve result shape -> create compex type
On ORM : get function -> domain method -> retrieve result shape -> create compex type
0
Hi Jose,
Damyan Bogoev
Telerik
I am glad to see you have managed to resolve the issue on your side.
Should you have further questions, do not hesitate to contact us back.
Damyan Bogoev
Telerik
OpenAccess ORM Q2 2013 brings you a more powerful code generation and a unique Bulk Operations support with LINQ syntax. Check out the list of new functionality and improvements shipped with this release.