View using Stored Procedure.
I was trying to learn to create views using a stored procedure, here I have created a small procedure.
create or replace
(P_PRODUCT_ID in number,
P_NAME OUT nvarchar2,
P_VALUE OUT nvarchar2)
into P_NAME, P_VALUE
where M_PRODUCT_ID = P_PRODUCT_ID;
Used that procedure, but it's not fetching any column on accepting a parameter.
I have gone through wiki also but didn't find any detailed explanation of on how to create a view using procedure.
is there any video or document explaining do's and not to do's for stored procedure based views?