Home » SQL & PL/SQL » SQL & PL/SQL » return a type record in a function??
return a type record in a function?? [message #224977] Fri, 16 March 2007 04:26 Go to next message
Messages: 56
Registered: March 2007
hi there!!!!

is there any way of creating a function that returns a type record(returning more than one value in a single object)
without creating the function in a package?

create function xpto()
return <type_record>


I saw some examples using a package where we define the type for the record but is there possible to do it without the package?

Re: return a type record in a function?? [message #224978 is a reply to message #224977] Fri, 16 March 2007 04:34 Go to previous message
Messages: 7062
Registered: December 2001
Senior Member
Yes, you can create types. Check out the SQL Reference for details.


Moved to Newbies.

Previous Topic: Query issue
Next Topic: how to delete blob
Goto Forum:

Current Time: Tue Oct 25 16:55:12 CDT 2016

Total time taken to generate the page: 0.10977 seconds