Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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


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 Member
Not what you were looking for? View more on this topic or Ask a question