1 Reply Latest reply on May 20, 2013 5:17 PM by gdarling - oracle

    Stored proc giving error in crystal report

    989367
      Hi,

      I am using Oracle provider for OLEDB connection in my crystal report it is giving below error when try to add stored proc:

      Query Engine Error:' ADO Error Code 0x
      Source :OraOLEDB
      Description : ORA-06550: line 1 column 7:
      PLS-00306 : wrong number or types or arguments in call to 'Stored proc name'
      ORA-06550 : line 1 , column 7:
      PL/SQL: Statement ignored
      Native error:'

      Crystal report used :
      Crystal report basic runtime for VS 2008(x86) version 10.5

      oracle version:
      oracle10202

      when I use Microsoft oledb provider for oracle, there is no issue, able to add proc and report generate succesfully.
      But I dont want to use Microsoft oledb provider for oracle.

      Please help to resolve this prob ASAP, i have tried in different blogs but couldnt find the solution.
        • 1. Re: Stored proc giving error in crystal report
          gdarling - oracle
          As the error message indicates, PLS-00306 occurs when you supply the wrong number or wrong types or arguments.

          What are the types of arguments?

          The two things that come to mind are:
          1) ORAOLEDB doesnt support ref cursors from procedures by default if I recall correctly. You need to enable it via PLSQLRSET
          http://docs.oracle.com/cd/E11882_01/win.112/e17726/using.htm
          2) MSDAORA uses a proprietary syntax (http://support.microsoft.com/kb/229919) for getting result sets from stored procedures, that the Oracle provider doesn't

          Short of that, you'll just need to verify what specific operation is occurring when the error occurs, via client side sqlnet trace for example.

          Hope it helps,
          Greg