wadha alketbi wrote:Is my way wrong? I want to check the date so I have condition
wadha alketbi wrote:now i have this exception:
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
Roel De Nijs wrote:using the NVL function is a very nice workaround to get rid of all if statements in your code.
wadha alketbi wrote: what you mean by this "you are not setting a value for the placeholders in your query."?
I read about NVL but I want it without using NVL
wadha alketbi wrote:Thank you so much for your help, now the method become like that but there is new exception:
ORA-01861: literal does not match format string
wadha alketbi wrote:Thank you, I follow your way but nothing happen with me ): I do not know what is the reason I have same exception
literal does not match format string
wadha alketbi wrote:I think the problem is in the date may be I have to use To_Date function
Dave Tolls wrote:TO_DATE in JDBC tends to indicate you're not using the correct datatypes.