Re: Problem with Views AND Stored Procedures

But this does change with 7.2, If I read an earlier posting correctly. If I have stated this incorrectly please let us ALL know. Thanks! ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Fri, 30 Aug 1996, Chris Drauch wrote: } 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 ... }