On Thu, Apr 12, 2001 at 02:54:31PM -0400, Mitch Clarvit wrote:
> Hey gang,
>
> Once again, I am here with a problem...this is one of the best places to get
> an answer...
>
> I am using Perl 5.003 to connect to an Oracle 8.1.5 Database. I have a
> field which is set up as NUMBER (4,2) which I assume equlas 9999.99...
Actually, NUMBER (4,2) equals 99.99. The first value is the maximum number
of digits, rather than the number of digits before the decimal point.
> As soon as I enter a number greater than 9 such as 10 or 11, my server
> crashes. If I try entering using SQL*Plus, I have no problems...only when
> using Perl.
>
> It bombs on a simple SQL command as:
>
> UPDATE courses SET ceus = 12 WHERE courseid = 'GFNUPI106';
I don't know why you would have a problem inserting 12 into a NUMBER (4,2)
field though.
BTW, perl5.003 is quite out of date. Unless you meant 5.005_03, you may
want to consider upgrading to a more recent version of perl.
Ronald
