Re: Stored procedure of a view

On Sun, 25 Aug 2002, depend3_at_yahoo.com wrote:
> My boss would like to have a stored procedure instead of a view. Is
> this possible?

No. A view is an object that you type and execute sql against. A stored procedure is something that you execute. You can get it to return a result set, but a stored procedure isn't something you select from.

> I thought you can only send one value to the outside world. Which
> variabletype do you recommend to return more values with a function if
> it is possible?

Well, now you are talking about functions. A function uses pl/sql, which is what a stored proc would mostly use, but they are two different things.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.