Stored procedure with parameters defined as FLOAT will be changed to a LongInteger in the Spotfire object.

Stored procedure with parameters defined as FLOAT will be changed to a LongInteger in the Spotfire object.

You have a stored procedure with input parameters defined as FLOAT. When you create the procedure object in the Information Designer, you see that the input parameters are set to a LongInteger and will only take an integer value.

Only a Longinteger will be added to the procedure object in the Information Designer. The datasource for the procedure is using the Direct Driver. In the URL you see: Jdbc:tibcosoftwareinc...

The drivers supplied with the software have known limitation. This driver is only meant for simple testing purposes and is not meant for production use.

Resolution:

You will need to use the vendor's database data driver. This will accept the FLOAT as a REAL data type.