Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 29, 2014 at 06:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded