on 12-25-2014 5:58 AM
Hi,
I'm using Crystal Report 2011 designer. I'm calling a stored procedure in CR which does some computations and populates the result in a Global Temporary Table. And, then I'm returning the resultset from the same using a Ref Cursor.
But when I run the report, it says "Failed to retrieve data from the database". But, the same works if i create an Oracle native connection.
But my limitation is that I can only use JDBC(JNDI) connection.
Please let me know how can I make the report work using JNDI connection only.
Crystal Version: CR 2011
DATABASE: Oracle 11g
Connection: JDBC(JNDI)
DB object used in report: Stored Procedue using GTT
Thanks & Regards,
Divyanshu Dhyani
Make sure you are using the latest SP for CR 2011:
https://websmp130.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/bobj_download/main_public.htm
Enter the following search string in the search box in the top right corner:
crystal jndi
The above search will return a n umber of useful resources.
- Ludek
Senior Support Engineer AGS Product Support, Global Support Center Canada
Follow us on Twitter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.