Access procedure inside a package

[Former Member]

We have recently upgraded to Oracle 12 db and are using oracle 11 client and crystal reports 13.0.5. We are not able to access procedures which are defined inside a package.

Is there any solution for this.

[former_member11696]

CR 13.0.5 is old amnd may have problems connecting to Oracle 12c.

Upgrade to SP 21 and test again:

https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

MUST READ the What's new to make this work now.

Don

[Former Member]

I have used Crystal with SPs in a package. You just need to name path

Execute SchemaName.PackageName.Procedure followed by parameter list.

It could be that the Crystal Reports user defined to access Oracle does not have sufficient rights to see Package or procedure.

Ian

[Former Member]

Sorry forgot to mention this can only be done in a command. You will then need to create command parameters to replicate the Procedure Parameters. NB You can not use Report Parameters.

In command Dialog you will see in top right a create button to create parameters.

Ian

[Former Member]

Thanks Ian for replying back. These reports were working fine when we were using oracle 11 database. We moved to Oracle 12 g database and now we are not able to access the procedures inside the packages.

we looked into this article and created a new procedure which is calling the package and then the procedure inside it. This solution is working but we have too many of them to change.

When we try to access the reports they give database connection error when we open the reports in viwer to try to update the connection it gives "Failed to retrieve data from the database. Details: ORA-00942: table or view does not exist [Database Vendor Code:942"

Any other suggestions for this ....

[Former Member]

Two things to try

Make sure Crystal Reports Oracle user for Logon has all the correct rights on Oracle 12

Or

In database ->Set datasource see image

Double click Overrridden Qualified Table name and Enter name of Stored Proc so same as shown in datasource.

This will remove any legacy schema names from SQL, go to Show SQlLand make sure Query is not picking up and incorrect schemas

Ian