Re: [Oracle][ODBC]Numeric value out of range.

On Fri, 2007-07-20 at 12:34 -0700, Paul Simon wrote:

Again, setting the sql type to SQL_VARCHAR via bind_param solves the error...

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 schema
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().



.

Relevant Pages

  • RE: Cant load Oracle.ppd
    ... > To: 'Jeff Urlwin' ... > I use this string to connect: ... > Have you installed the Oracle client software? ... > rebooted since installing the Oracle client? ...
    (perl.dbi.users)
  • Re: ADO - accessing oracle
    ... >> I have prepared an excel form for users in our company to get external ... The connection string references the ... >> connection object through any service provider drivers to oracle client ... The oracle client processes the sql string ...
    (microsoft.public.excel.programming)
  • Re: Connecting to oracle
    ... I found the problem by researching the string in Google... ... nothing to do with the connection... ... > Is your Oracle Client correctly configured(In your path and Oracle_Home ...
    (microsoft.public.inetserver.asp.db)
  • Re: [Oracle][ODBC]Numeric value out of range.
    ... the problem started when I upgraded the oracle client (including oracle odbc ... driver) from 9i to 10g. ... Your message seems to imply that to_dateshould not require a string. ...
    (perl.dbi.users)
  • Re: Cant connect MS Access to 8i
    ... It is the *standard* communication driver which comes with Oracle ... Server and Oracle client. ... you can't install the Oracle ODBC ...
    (comp.databases.oracle.misc)