Hi all,
I am using this SQL statement to fetch data from oracle
and passing the date to oracle parameter asCode:str = "select * from Master where CreatedDttm = TO_DATE(:p_StartDate,'MM/DD/YYYY')"
And executing this command I getting error thatCode:oParameter.ParameterName = "p_StartDate" oParameter.Value = "01/01/2009" oParameter.OracleType = OracleType.DateTime oParameterList(0) = oParameter
Invalid varriable name or number ?
What I am doing wrong here ?
I did the steps mentioned in post. But the same error




Reply With Quote