|
Re: Unable to pass parameters when using Postgresql functions [message #506244 is a reply to message #506077] |
Wed, 06 January 2010 16:34 |
|
Does it work if you just call
select get_date(?)
or hard code the parameter?
Jason
Smitha wrote:
> I have a BIRT report that runs on Pstgresql 8.3 queries. When I pass
> parameters to regular queries and set the parameters using the dataset
> editor, then there is no issue. For example, select * from table where
> column = ? works just fine.
>
> However, when I try to call a Postgresql function in the query and pass
> parameters to this function, I get an error.
>
> For example , if I have a Postgresql function called get_dates(year
> integer)
> and I call it in a report by saying:
>
> select * from get_date(?)
>
> This throws an error.
>
> Can someome please tell me how to call postgresql functions in queries
> inside a BIRT report?
>
> Many thanks!
|
|
|
Powered by
FUDForum. Page generated in 0.03446 seconds