RE: PL/SQL Procedure Need Help seriously

Oracle Procedures can return calculated values or dates just fine.

CREATE OR REPLACE PROCEDURE AGE( birth_date DATE) RETURNS DATE AS
	RETURN(  round((sysdate - birth_date)/365, 0)); 
END; 


>From: [email protected] 
>
>
>Leonard, 
>
>Could you please point me to the documentation that states that a procedure 
>is not meant to return a calculated value. 
>
>So are you saying that if you need more then one calculated value returned 
>you would create two functions instead of one procedure?? 




---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].