Eclipse Community Forums: BIRT

Home » Archived » BIRT » stored procedure

Wed, 30 March 2005 12:08

Eclipse User

Originally posted by: david_shapiro.yahoo.com

I just started looking at BIRT and maybe I'm missing something obvious, but
I'm not having any luck creating a data set using a stored procedure. How
is this supposed to be done?

Re: stored procedure [message #24203 is a reply to message #23855]

Thu, 31 March 2005 16:37

Eclipse User

Dave,

You can put in a simple stored procedure call statement as the query in
the JDBC textual query editor.
The JDBC ODA plugin included in BIRT currently supports SQL select query
and simple stored procedure query. That is, those that 1) use scalar
input parameters only or no parameters, and 2) retrieve a single result
set directly, like those in SQL Server or Sybase (instead of via a cursor
output parameter like those in Oracle).
We encourage the BIRT community to provide additional Open Data Access
(ODA) extensions to handle various types of data sources, including
complex stored procedures.

Linda

Previous Topic:	About chart
Next Topic:	Suggestion for ODACONFIG.XML

Goto Forum:

-=] Back to Top [=-

Current Time: Sat May 10 13:11:44 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter