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
DB object used in report: Stored Procedue using GTT
Thanks & Regards,