Re: Function

rajeshdhumal_at_gmail.com wrote:
> i wants to create a function which will return more than one parameter

Use a pipelined table function or make one of your parameters an OUT.

It looks to me like you settled on the solution, a function, without any regard to whether a procedure would be more appropriate: It would be.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org