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
Owner SCOTT MYLIST
How do I get the catalog attribute in Crystal Java Reporting Component (JRC) ? What is the right qualified name for this ?