I got the following error when try to create a function to return an
integer and SETOF refcursor. I want to get refcursors back along with an
Out parameter in one function. There seems to be a conflict on return
type. How do I fix it? Thanks.
ERROR: function result type must be integer becaus
I got only thing like "43 | | portal 4>" returned as a single row to my .NET client. Any other clients
can use the function? Please advise.
Albe Laurenz *EXTERN* wrote:
Chuck Bai wrote:
I have the following function:
CREATE OR REPLACE FUNCTION test_refcursor(INOUT tcount integer
t integer, refcursor, refcursor). I want to add logic
to my INOUT parameter inside the function and return it back to client,
as well as returning the two refcursor results. How to modify this
function and how to test it in SQL to achieve my goal?
Merlin Moncure wrote:
On Sun, May 11, 2008 a
I have the following function:
CREATE OR REPLACE FUNCTION test_refcursor(INOUT tcount integer, OUT
o_user refcursor, OUT o_name refcursor)
RETURNS record AS
$BODY$
BEGIN
tcount := tcount + 1;
OPEN o_user FOR SELECT * FROM user_table;
OPEN o_name FOR SELECT * FROM name_table;
END;
$BOD
