SQL & PL/SQL

Hi

How to Insert date in 'DD/MM/YYYY' format in oracle using stored procedure?

This is my Input data.
11/25/2007.

By using below query, it is inserted into database.

sql>Insert into tblname values(to_date('11/25/2007','MM/DD/YYYY'));

But using stored procedure, the same query is not running.
It shows error like
ORA-01843: not a valid month ORA-06512: at line 1

Procedure:

create or replace procedure Date_Test(datejoin in DATE) is
begin
insert into datetest values(to_date(datejoin,'MM/DD/YYYY'));
end Date_Test;

I had used 'nls_date_language = american' also.

Prcodeure is created but not worked in jsp. The same error is thrown.

Pls provide a solution