Skip to Content
avatar image
Former Member

Access procedure inside a package

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 01, 2017 at 07:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

      datasource.jpg (15.4 kB)
  • Sep 08, 2017 at 07:41 PM

    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

    Add comment
    10|10000 characters needed characters exceeded