Re: [Oracle][ODBC]Numeric value out of range.
- From: getpsimon@xxxxxxxxx (Paul Simon)
- Date: Tue, 24 Jul 2007 06:02:30 -0700 (PDT)
--- Jared Still <jkstill@xxxxxxxxxxx> wrote:
On Fri, 2007-07-20 at 12:34 -0700, Paul Simon wrote:No, I'm using to_date() to insert a string like '06/2006' into a DATE field. I agree with you
Again, setting the sql type to SQL_VARCHAR via bind_param solves the error...schema
Looking back, the problem started when I upgraded the oracle client (including oracle odbc
driver) from 9i to 10g. There's something not right here - even though the data type in
is DATE, the function, TO_DATE(?,'MM/YYYY'), requires a string.
Your message seems to imply that to_date() should not require a string.
If that is so, it is incorrect. to_date() does require string.
Are you trying to reformat a date for display? Then use to_char().
that to_date() requires a string, but evidently the software does not. I'd like to know where
the disagreement is. I initially thought it was DBI or ODBC, but now I'm not sure.
.
- References:
- Re: [Oracle][ODBC]Numeric value out of range.
- From: Jared Still
- Re: [Oracle][ODBC]Numeric value out of range.
- Prev by Date: Re: Problem compiling DBD::Sybase with CentOS 4.5
- Next by Date: RE: Christophe MUSIELAK est absent(e).
- Previous by thread: Re: [Oracle][ODBC]Numeric value out of range.
- Next by thread: use DBI;
- Index(es):
Relevant Pages
|
