Re: Problem with Views AND Stored Procedures

Rajeev SRK Nimmagadda wrote } } [snipped] create procedure ... } }If I run with execute procedure it works great. }EXECUTE PROCEDURE get_status(ssn, 1) it returns four values. } }Bt I can't use it in the following Format. } }create view v_tempstatus (ssn , stat_cd, status_dt, cl_dys, tr_days) }AS } SELECT ssn, get_status(ssn, 1) from Student } where ssn < "100000000"; } }It gives the Error 684 : The procedure returns too many values. I was asking about the same the other week ;-) You can't use procedures returning more than ***value*** within select statements ;) ;) -- Chris Drauch <cdr@xteam.co.at> ... just speaking for myself ...