Solved

Query against Oracle database - parameter

Posted on 2010-09-15
2
261 Views
Last Modified: 2012-08-13
Hi,
when I execute vb code below I receive error message "Ora - 01843: Not a Valid Month"
Please help me to solve the problem..what did I make wrong...
Query is executed against Oracle Database....
Thank you....
Dim cmd1 As New System.Data.OleDb.OleDbCommand
        cmd1.Connection = conn1
        cmd1.CommandType = CommandType.Text
        cmd1.CommandText = "select ACCOUNT_ID from my_table where full_date >= to_date(:datum_val1, 'dd.mm.yyyy') AND full_date <= to_date(:datum_val2, 'dd.mm.yyyy')"
        cmd1.CommandTimeout = 0
cmd1.Parameters.Add(":datum_val1", OleDbType.VarChar)
        cmd1.Parameters(":datum_val1").Value = Me.DateTimePicker1.Value.ToString("dd.mm.yyyy")
        cmd1.Parameters.Add(":datum_val2", OleDbType.VarChar)
        cmd1.Parameters(":datum_val2").Value = Me.DateTimePicker2.Value.ToString("dd.mm.yyyy")
        Dim rdr As OleDbDataReader = cmd1.ExecuteReader

Open in new window

0
Comment
Question by:alsam
2 Comments
 
LVL 1

Accepted Solution

by:
ronythom earned 500 total points
ID: 33685913
what is the value on datum_val1 and datum_val2. Is it included the ".", if not it cause the problem

to_date('01.03.1990','DD.MM.YYYY') then no prpblem

to_date('01031990','DD.MM.YYYY') it will return error
0
 
LVL 1

Author Closing Comment

by:alsam
ID: 33688998
Ok I found wghere the problem was. I had to change Me.DateTimePicker2.Value.ToString
into Me.DateTimePicker2.Text and it works OK...
Also, :datum_val should be changed in ? in statement....
Anyway thank you for your time and effort...
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question