| Birt cannot get data from Postgres's RefCursor, so , How do i do this? [message #1223521] |
Mon, 23 December 2013 11:47 |
Eclipse User |
|
|
|
Hi everybody, sorry for my english, i have a problem with a birt dataset, i can't get data from refcursor from my postgres function. For example:
POSTGRES (JDBC CONNECTOR V9.2)
========
/*THE PARAMETER in_test_id IS ONLY A TEST!!*/
CREATE OR REPLACE FUNCTION public.test_birt(in_test_id bigint DEFAULT NULL::bigint)
RETURNS refcursor AS
$BODY$
DECLARE
query text;
tcursor refcursor = 'tcursor';
BEGIN
query := 'SELECT * FROM MY_TABLE';
OPEN tcursor FOR execute query;
return tcursor;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
BIRT (VERSION 3.2.0)
====
DATASET
|_ MYDATASET
|_ select * from test_birt(?::bigint)
Well, when i put the dataset over my report page, this print the word "tcursor"
|
|
|
Powered by
FUDForum. Page generated in 0.03303 seconds
Home