HI
How can i call from function to function in Oracle pl\sql?
I need a sample program .Please clarify my doubt.Pls.
Arun..
Here's the first function declaration:
----------------------------------------------------------------------------------------------------
CREATE OR REPLACE FUNCTION firstFunc(pParm1 IN Varchar2)
RETURN BOOLEAN AS
vDate DATE;
BEGIN
SELECT sysdate INTO vDate FROM dual;
--call function two
if secondFunc(vdate) = 'WEDNESDAY' then
dbms_output.put_line("It's wednesday");
else
dbms_output.put_line("It's not wednesday");
end if;
END firstFunc;
----------------------------------------------------------------------------------------------------
Here's the second function declaration, that is called by the first:
----------------------------------------------------------------------------------------------------
CREATE OR REPLACE FUNCTION secondFunc(pParm1 IN DATE)
RETURN VARCHAR2 AS
vDay varchar2(20);
BEGIN
RETURN to_char(pParm1, 'DAY');
END secondFunc;