Home » SQL & PL/SQL » SQL & PL/SQL » Can we use the temp table in the function which uses ref cursor (Oracle 10g)
Can we use the temp table in the function which uses ref cursor [message #572113] Thu, 06 December 2012 03:32 Go to next message
vino06cse57
Messages: 130
Registered: July 2011
Location: chennai
Senior Member
Hi All

Please provide me a example to use temp table in function with only ref cursor.

I need to use for the reporting pupose.
Thanks
Re: Can we use the temp table in the function which uses ref cursor [message #572121 is a reply to message #572113] Thu, 06 December 2012 04:00 Go to previous message
Michel Cadot
Messages: 58638
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please describe in details what you need to do with a working Test case: create table and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Please explain why you need a temp table.

Regards
Michel
Previous Topic: Restriction on Analytical functions
Next Topic: SQL Error: ORA-01861: literal does not match format string
Goto Forum:
  


Current Time: Thu Jul 31 19:48:32 CDT 2014

Total time taken to generate the page: 0.14291 seconds