Print Page | Close Window

Oracle stored procedure error

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=14914
Printed Date: 22 Apr 2025 at 6:22am


Topic: Oracle stored procedure error
Posted By: capone
Subject: Oracle stored procedure error
Date Posted: 09 Nov 2011 at 2:31pm
Hello all,

I am trying to add a Stored Procedure through the Database Expert to my report. My Tables and Views are working fine. I can see my Stored Procedures, but when I press "OK" on the Enter Value prompt, I get a Database Connector Error: 'Cannot obtain error message from server.' The Stored Procedure is not added to my report.

Alternatively, if I don't press okay but hit the "X" to close the Enter Value prompt, the Stored procedure is added to my report, but the table shows up blank.

I am using Crystal Report 2008 with oracle Server 10, and an ODBC connection (I have tried both oracle Server and oracle Native Client as drivers.

Do i need to setup anything in the oracle ODBC

Has anyone experienced this before or know of a possible explanation?

Thank you in advance and hope this ends up helping someone else also!


Replies:
Posted By: Franklin
Date Posted: 11 Nov 2011 at 9:25am
I am currently having the same problem. The problem seems to be when I try to pass a parameter from Crystal to the stored procedure. When no parameter is present in the sp, then it works, but when adding the parameter back, I am getting this error.
 
I hope someone has an answer to this issue. It is driving me nuts!


-------------
Franklin


Print Page | Close Window