"Pro*C - ORA 01858 Error "

I declared a Host variable to hold a date field.

varchar2 temp_date[9];

   short temp_date_id;

I am selecting a date field from a table into this variable(This DATE field in the table is NULL).
When I try to insert into table it gives me ORA-01858 Error.

to_date(:temp_date,'DD-MON-YY');
nvl(:temp_date,'');

I tried to_date, nvl functions but it did not help me.

Can someone suggest me where I am doing wrong.

Thanks Received on Thu Jan 18 1996 - 00:00:00 CET