Stored procedure with parameters defined as FLOAT will be changed to a LongInteger in the Spotfire object.
Article ID: KB0081628
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All Versions |
Description
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.
Issue/Introduction
Stored procedure with parameters defined as FLOAT will be changed to a LongInteger in the Spotfire object.
Resolution
You will need to use the vendor's database data driver. This will accept the FLOAT as a REAL data type.
Feedback
Yes
No
Powered by
