[sajusv]

Hi every body
I am using a stored procedure to insert values into a table which contain a date datatype. I pass the date in MM-DD-YYYY format.
When i execute the querry it shows error invalid month.

create or replace procedure sample_I
(
P_no varchar2,
P_date date
)
as
begin
insert into sample values(P_no ,to_date(P_date,'MM-DD-YYYY' ));
end;

[namliam]

Try passing the date into a string value

create or replace procedure sample_I
(
P_no varchar2,
P_date varchar2
)

This way there are no implicit conversions. If your P_Date is allready a date there is no need to use the To_Date function in your insert statement.

Greetz

[sajusv]

HI Greetz
Thank you very much . Thank you

[WilliamR]

Well, if you are already working with Oracle DATE values (as you should) then your procedure is simply

CREATE OR REPLACE PROCEDURE sample_I
    ( p_no   VARCHAR2
    , p_date DATE )
AS
BEGIN
    INSERT INTO sample
    ( col1
    , col2 )
    VALUES
    ( p_no
    , p_date );
end;