Skip to Content
0
Former Member
Jul 21, 2009 at 08:13 AM

How to use oracle package in crystal report ?

378 Views

Hi,

I create a stored procedure in oracle package for a report. From Crystal Report XI I can preview the data.

Scott is the schema name. AREAL1 is my stored procedure in a package named MYLIST.

From jdev, if I use qualified name = SCOTT.AREAL1, I get error 'com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: JDBC Error: ORA-06550: line 1, column 16: PLS-00302: component 'SCOTT' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored -


Error code:-2147467259 Error code name:failed'

If I change qualified name to SCOTT.MYLIST.AREAL1, the error is 'com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: The table 'SCOTT.MYLIST.AREAL1' could not be found.---- Error code:-2147467259 Error code name:failed'

The difference in datasource location (crystal report) between report with stand alone stored procedure and packaged procedure is

stand alone procedure packaged procecdure

Catalog SCOTT

Owner SCOTT MYLIST

How do I get the catalog attribute in Crystal Java Reporting Component (JRC) ? What is the right qualified name for this ?

Thanks