Re: Create a view using OUT values from a procedure - how?

In ASNI SQL it should look something like that

create type x as (a int, b int);
create function foobar...
returns x
.....

return x().a(val1).a(val2);
...

create view v(a, b)
as select my_x.a, my_x.b

   from (select foobar(c1) as my_x from t)

I'm aware the Oracle syntax is not quite the same, but it should be equivalent...

Cheers
Serge Received on Fri Oct 08 2004 - 07:44:00 CDT