Home » SQL & PL/SQL » SQL & PL/SQL » Function to return Nested Table
icon5.gif  Function to return Nested Table [message #268038] Mon, 17 September 2007 05:09 Go to next message
sayuri
Messages: 20
Registered: October 2006
Location: Cape Town
Junior Member
How do code my function to return a nested table? Can anyone maybe help me here please ?

Thanks
Re: Function to return Nested Table [message #268040 is a reply to message #268038] Mon, 17 September 2007 05:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't return a "nested table", you can return a collection.

Regards
Michel
Re: Function to return Nested Table [message #268049 is a reply to message #268040] Mon, 17 September 2007 05:53 Go to previous messageGo to next message
sayuri
Messages: 20
Registered: October 2006
Location: Cape Town
Junior Member
How will the code look for that?
Re: Function to return Nested Table [message #268053 is a reply to message #268049] Mon, 17 September 2007 06:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
create type ... as object ...
create type ... as table ...
create function ... return <previous_type>

Regards
Michel
Re: Function to return Nested Table [message #268062 is a reply to message #268053] Mon, 17 September 2007 07:09 Go to previous message
sayuri
Messages: 20
Registered: October 2006
Location: Cape Town
Junior Member
Thanks !!
Previous Topic: validation
Next Topic: capturing milliseconds in oracle8
Goto Forum:
  


Current Time: Sun Dec 11 08:20:00 CST 2016

Total time taken to generate the page: 0.13113 seconds