Oracle Query

query.sql

create or replace FUNCTION F_MEDIA 
(
  P_DATE IN VARCHAR2 DEFAULT 24-1-2013 
, P_INFLUENCE IN VARCHAR2 DEFAULT 'p' 
, P_MEDIATYPE IN VARCHAR2 DEFAULT 'tv'
) RETURN NUMBER AS
    
    CURSOR input is SELECT COUNT(CONTRACTS.CONTRACTDATE)  
    FROM CONTRACTS, MEDIA
    WHERE
        TO_CHAR(TO_DATE(P_DATE,'DD-MM-YYYY'), 'YYYY-MM-DD') = TO_CHAR(TO_DATE(substr(CONTRACTDATE, 0, 19),'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD')
      AND
        MEDIA.INFLUENCE = P_INFLUENCE
      AND 
        MEDIA.KIND = P_MEDIATYPE;
        
    output number;
        
BEGIN
  open input;
  fetch input into output;
  RETURN output;
END F_MEDIA;