Re: "Pro*C - ORA 01858 Error "

In article <4dmgf9$jmf_at_gazette.medtronic.com>, LoginName_at_medtronic.com (YourNameHere) wrote:
> When I try to insert into table it gives me ORA-01858 Error.
>
> to_date(:temp_date,'DD-MON-YY');
> nvl(:temp_date,'');
>

If you're trying to insert a NULL date, use a null indicator variable like this:

temp_date_ind=-1;
exec sql insert...

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

-- 
Billy O'Connor                  email:  billyoc_at_iii.net
D.P.S. Consulting, Boston MA      CIS:  74021,530 
"Congress shall make no law ... abridging the freedom of speech, or 
 of the press; or the right of the people peaceably to assemble."