Print Page | Close Window

Cannot use stored procedure

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=18255
Printed Date: 20 Apr 2025 at 3:02pm


Topic: Cannot use stored procedure
Posted By: victor2012
Subject: Cannot use stored procedure
Date Posted: 13 Dec 2012 at 5:10am

Hi all,

Please help...

When running the crystal report using stored procedure, we met the error message "wrong number or wrong type of parameters".

Not sure the correct version of ODBC driver is using or other Oracle privilege issue. It cannot identify the stored procedure with cursor return parameter. 

Below is the software version we are now using (details config is attached):

 AIX version: 7.1

Oracle db version: 11.2.0.1.0

ODBC Driver (In C:\Windows\System32): 11.02.00.01

ODBC Driver (In C:\Windows\SysWOW64) : 11.02.00.01

Crystal Server: SAP Crystal Server 2011 SP4

 

Thanks in advance,
Victor


Print Page | Close Window