How to call function in INteractive Report!!
665735Dec 29 2009 — edited Jan 31 2011Hi All,
After investing on interactive report i have came to know that we can have only sql query but not Dynamic Sql query!
By using PIPELINED FUNCTIONS we can use dynamic sql in Apex Interactive Reports.
Here is the url for refernece- http://sungur.wordpress.com/2009/10/11/apex-interactive-reports-with-dynamic-sql/
When i had tried to implement the the above one it is throwing error as
Query cannot be parsed, please check the syntax of your query. (ORA-06575: Package or function GET_TABLE_ROWS2 is in an invalid state)
Can any one help me out how to overcome the scenerio and resolve the problem?
Since it is urgent can any one help me out to resolve it.
Thanks in Advance,
Anoo..