Create View, executing a stored procedure

[rdharmar]

Is it possible to do something like this to create a view;

Select * from
( Execute Stored_Procedure_name ).

Thanks in advance.

 

[avjoshi]

I am not surte if you can select on procedures but if it is a function you can say,

select <function_name> from dual;

Anand

 

[sem]

No, but if your procedure returns table name, you may use DYNAMIC SQL.

Regards, Dima

http://seminihin.narod.ru