PL/SQL Procedure Need Help seriously
"koh sze jie" <[email protected]> Wed, 23 Apr 2003 18:29:53
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-957338-2003.04.23-18.09.04--gcdod-oracle#[email protected]> |
this is my procedure whereby you input a date value into the procedure to
calculate ur age.
variable g_age number
create or replace procedure cal_age
( mybirthdate in date
myage out number )
is
begin
myage := (sysdate - mybirthdate)/365
:g_age := myage;
end;
print g_age
Here is my problem
how do i input a date value into my procedure..
i tried
execute cal_age('14-NOV-84');
but it return an error and i know it wrong as well.
but i cant embed a to_date function within the parenthesis.
so any1 please help ?
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to [email protected].