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.

book

Article ID: KB0081628

calendar_today

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.

Resolution

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

Issue/Introduction

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