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

2007-07-24 Thread Paul Simon
--- Jared Still <[EMAIL PROTECTED]> wrote: > 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 oracl

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

2007-07-20 Thread Paul Simon
> > > I'm guessing that DBI is making incorrect assumptions about SQL Types > > > somewhere... Is this > > > what's happening? > > > > > > It could be differences between versions, as you apparently upgraded the > > client only. > > > > You didn't mention the database version. > > > > Try runni

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

2007-07-18 Thread Paul Simon
> > I'm guessing that DBI is making incorrect assumptions about SQL Types > > somewhere... Is this > > what's happening? > > > It could be differences between versions, as you apparently upgraded the > client only. > > You didn't mention the database version. > > Try running your script without

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

2007-07-16 Thread Paul Simon
--- Paul Simon <[EMAIL PROTECTED]> wrote: > Hi. I'm new to the list. I have a perl script that was working fine until I > upgraded my > Oracle > client 9i to 10g (instant client). I'm inserting data into an Oracle database > via DBD-ODBC. > The > inse

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

2007-07-09 Thread Paul Simon
Hi. I'm new to the list. I have a perl script that was working fine until I upgraded my Oracle client 9i to 10g (instant client). I'm inserting data into an Oracle database via DBD-ODBC. The insert will succeed if I do not bind the variables ($rec->{'YEAR APPROVED SES'} and $rec->{'YEAR APPLIED