Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Birt cannot get data from Postgres's RefCursor, so , How do i do this?
Birt cannot get data from Postgres's RefCursor, so , How do i do this? [message #1223521] Mon, 23 December 2013 16:47
Gaston Flores is currently offline Gaston Flores
Messages: 1
Registered: December 2013
Junior Member
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"

Previous Topic:locale text on pie chart category series label
Next Topic:how to set excel column width as content width
Goto Forum:
  


Current Time: Sun Oct 26 07:09:41 GMT 2014

Powered by FUDForum. Page generated in 0.10013 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software