Crystal Report is not able to pull data from GTT...

[Former Member]

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

[former_member183750]

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