Community
Participate
Working Groups
Hi, I am new to Birt Development. Now, i need to create a dataset based on oracle stored procedure and one of the parameter is collection (Oracle Record type variable). I would like to declare the variable before calling the procedure. So, Can you pl. tell me where to declare the record type variable before calling the procedure For ex. refcur_pkg.ser_row_by_ser_col( p_report_id => 3, p_category_code => 'FUND', p_reg_id => 229, p_include_region => 'N', p_include_state => 'Y', p_series_delimiter => ';', p_cursor => temp_query Where refcur_pkg = Oracle package ser_row_by_ser_col = procedure in refcur_pkg temp_query = Oracle record type and declared in the package as as follows TYPE rec_ser_row_by_ser_col_type IS RECORD ( reg_sort_number NUMBER (3), reg_name qis_regions.reg_name%TYPE, .... .... value_rank NUMBER (3), font_style qis_report_series.font_style%TYPE );
The Oracle record type parameter has not been supported by BIRT yet. We will investigate to see the possibility to add it in near future. Meanwhile, please use BIRT newsgroup ( news://news.eclipse.org/eclipse.birt ) to ask questions. The bugzilla is used for bug tracing only. Thanks. Lin
This is a DB specific feature, suggest to defer.
I cannot see the possibility of doing this in near future, especially after we remove "any" type support. Suggest to defer to future.
Record type is an Oracle-specific extension and I also don't see a straightforward way to support this in the generic oda.jdbc driver. Deferring this to future. If we get enough requests to support various DB-specific features we will consider adding extensions to oda.jdbc driver, or develop DB-specific drivers to address those.