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

>
> 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

I was able to create the object and then use it and return the object from my function without issue. The problem I'm having is using it in the view, or even in a simple Select statement. My error parser says my object (e.g. my_x.a) is an invalid identifier. It seems we are trying to call the object before we creat an instance of it.

Mike Received on Fri Oct 08 2004 - 10:08:14 CDT