I am using Oracle stored procedures and I have used IN parameters for input and INOUT parameter of REF_CURSOR TYPE for returning resultset in Crystal Report 2008 by using package. Now when I am trying to add the package in the Crystal Report, parameter input box prompts, I enter some values and gets Database Connector error: 'cannot obtain error message from server'.
But when I do not use INPUT parameters and use OUT parameter of REF_CURSOR type it runs well without any issues.
We are using ODBC connection for Oracle.
Kindly suggest.