Skip to main content
A
Anonymous
February 11, 2011
Question

[Macromedia][Oracle JDBC Driver]Numeric overflow

  • February 11, 2011
  • 1 reply
  • 1455 views

I am moving from CF 6.1 to CF 9 using Oracle 9i.  I get the following error when I use cfstoredproc to call a procedure in a package: [Macromedia][Oracle JDBC Driver]Numeric overflow.  In spite of throwing the error, the stored procedure seems to execute properly. Has anyone encountered this problem?

    This topic has been closed for replies.

    1 reply

    A
    Adam Cameron.
    Inspiring
    February 12, 2011

    Can you replicate this with specific values? It •sounds• like you're trying to put a number in a column which lacks the capacity. Although this would be unlikely to be something to crop up just because of an upgrade?

    What's the bit of code in the proc which is erroring, and what values are you feeding it?

    Also, what happens when you call the proc with those values via SQL Developer or TOAD or something?

    --

    Adam

    A
    Anonymous
    February 16, 2011

    I cannot consistently replicate the problem.  Values that work the first time may not work the second time.  The data is always entered in the database, but sometimes an error message is thrown regardless of the fact that the data was entered into the database. Calling the procedure with PL/SQL works every time.  Here is a dump of the info. from cfcatch:

    The database operation failed.

    Type: Database

    Message: Error Executing Database Query.

    Detail: [Macromedia][Oracle JDBC Driver]Numeric overflow.

    Native Error Code: 0

    SQLState: HY000

    SQL: {call pk_name.proc_name ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) , (param 10) , (param 11) , (param 12) , (param 13) , (param 14) , (param 15) , (param 16) , (param 17) , (param 18) , (param 19) , (param 20) , (param 21) , (param 22) , (param 23) , (param 24) , (param 25) , (param 26) , (param 27) , (param 28) , (param 29) , (param 30) , (param 31) , (param 32) , (param 33) , (param 34) , (param 35) , (param 36) , (param 37) , (param 38) , (param 39) , (param 40) , (param 41) , (param 42) , (param 43) , (param 44) )}

    Query Error: [Macromedia][Oracle JDBC Driver]Numeric overflow.

    Where:

    (param 1) = [type='INOUT', value='null', sqltype='cf_sql_integer'] ,

    (param 2) = [type='IN', class='java.lang.Integer', value='41014', sqltype='cf_sql_integer'] ,

    (param 3) = [type='IN', class='java.lang.String', value='N', sqltype='cf_sql_char'] ,

    (param 4) = [type='IN', class='java.lang.String', value='N', sqltype='cf_sql_char'] ,

    (param 5) = [type='IN', class='java.lang.String', value='LastName, FirstName ', sqltype='cf_sql_varchar'] ,

    (param 6) = [type='IN', class='java.lang.String', value='12345', sqltype='cf_sql_varchar'] ,

    (param 7) = [type='IN', class='java.lang.String', value='10063', sqltype='cf_sql_varchar'] ,

    (param 8) = [type='IN', class='java.lang.String', value='LastName, FirstName', sqltype='cf_sql_varchar'] ,

    (param 9) = [type='IN', class='java.lang.String', value='(123) 456-7890', sqltype='cf_sql_varchar'] ,

    (param 10) = [type='IN', class='java.lang.String', value='abc_201102_163', sqltype='cf_sql_varchar'] ,

    (param 11) = [type='IN', class='java.lang.String', value='test', sqltype='cf_sql_varchar'] ,

    (param 12) = [type='IN', class='java.lang.String', value='test', sqltype='cf_sql_varchar'] ,

    (param 13) = [type='IN', class='java.lang.String', value='test', sqltype='cf_sql_varchar'] ,

    (param 14) = [type='IN', class='java.lang.String', value='test', sqltype='cf_sql_varchar'] ,

    (param 15) = [type='IN', class='java.lang.String', value='test', sqltype='cf_sql_varchar'] ,

    (param 16) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] ,

    (param 17) = [type='IN', class='java.lang.Integer', value='38', sqltype='cf_sql_integer'] ,

    (param 18) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] ,

    (param 19) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] ,

    (param 20) = [type='IN', class='java.lang.Integer', value='2', sqltype='cf_sql_integer'] ,

    (param 21) = [type='IN', class='java.lang.String', value='EA', sqltype='cf_sql_varchar'] ,

    (param 22) = [type='IN', class='java.lang.String', value='test', sqltype='cf_sql_varchar'] ,

    (param 23) = [type='IN', class='java.lang.String', value='D', sqltype='cf_sql_varchar'] ,

    (param 24) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] ,

    (param 25) = [type='IN', value='null', sqltype='cf_sql_varchar'] ,

    (param 26) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] ,

    (param 27) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] ,

    (param 28) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] ,

    (param 29) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] ,

    (param 30) = [type='IN', value='null', sqltype='cf_sql_integer'] ,

    (param 31) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] ,

    (param 32) = [type='IN', value='null', sqltype='cf_sql_varchar'] ,

    (param 33) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] ,

    (param 34) = [type='IN', class='java.lang.String', value='A5E', sqltype='cf_sql_varchar'] ,

    (param 35) = [type='IN', class='java.lang.String', value='B5', sqltype='cf_sql_varchar'] ,

    (param 36) = [type='IN', class='java.lang.String', value='CEJ', sqltype='cf_sql_varchar'] ,

    (param 37) = [type='IN', class='java.lang.String', value='A', sqltype='cf_sql_varchar'] ,

    (param 38) = [type='IN', class='java.lang.String', value='15', sqltype='cf_sql_varchar'] ,

    (param 39) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] ,

    (param 40) = [type='IN', class='java.lang.String', value='ABC DEF - GHI JK', sqltype='cf_sql_varchar'] ,

    (param 41) = [type='IN', class='java.lang.String', value='ABCD EF1234 GHI JK', sqltype='cf_sql_varchar'] ,

    (param 42) = [type='IN', value='null', sqltype='cf_sql_date'] ,

    (param 43) = [type='OUT', sqltype='cf_sql_integer'] ,

    (param 44) = [type='OUT', sqltype='cf_sql_varchar']

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices