Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Large number and external procedures

Large number and external procedures

From: Mike <mca_at_arlut.utexas.edu>
Date: 3 Apr 2002 08:40:31 -0800
Message-ID: <1bd54855.0204030840.181cd1d9@posting.google.com>


I am tring to pass values greater than 2147483687 (2^31 - 1) to an external C procedure. I am calling the external C procedure from a PL/SQL function. I defined the data to be of type binary_integer. I get a numeric overflow error with data greater than 2^31 - 1. I then redefined my data to be of type number. I was then able to pass the data to the external C procedure but the data is not correct. The data in my external C procedure is defined as unsigned int. Does anyone know how to correctly pass values greater than 2^31 - 1 to an external C procedure.

Thanks,
Mike Received on Wed Apr 03 2002 - 10:40:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US