Forum Stats

  • 3,783,394 Users
  • 2,254,768 Discussions
  • 7,880,377 Comments

Discussions

Stored proc giving error in crystal report

989367
989367 Member Posts: 3
edited May 20, 2013 1:17PM in Oracle Provider for OLE DB
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.

Answers

  • 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
This discussion has been closed.