I have a table which has a field 'date_created' of type DATE.

I would like to pass this date_created as a parameter into my Stored Procedure. What should be the type of it??


Here's my Stored Procedure..

CREATE OR REPLACE PROCEDURE SP_NEW_USERS(currentBeginDate IN DATE, currentEndDate IN DATE,
changeFromPreviousMonth OUT NUMBER) IS
tmpVar NUMBER;

BEGIN
tmpVar := 0;
select count(user_id) into tmpVar from oradba.up_user where (date_created between currentBeginDate and currentEndDate);

DBMS_OUTPUT.PUT_LINE(tmpVar);
EXCEPTION
WHEN NO_DATA_FOUND THEN
Null;
WHEN OTHERS THEN
Null;
END SP_NEW_USERS;