TIBCO Spotfire Information Services treats Oracle Functions as Stored Procedures when using the DataDirect driver for Oracle
Article ID: KB0074016
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All |
Description
After creating an Oracle function as a procedure element with the Oracle DataDirect driver, Spotfire reads it as an Oracle stored procedure rather than an Oracle function. Once this happens, even if the connection string of the data source is updated to the the thin driver provided by Oracle, the behavior doesn't change.
Example: Below is the sample call which gets triggered when an Oracle function is called from the Spotfire using the DataDirect driver:
{call "Test"."abc"(0) }
However, the ideal call should be like below:
{? = call "Test"."abc"(0) }
Environment
All
Resolution
The only way to correct this behavior is to create the information model using the Oracle Thin driver connection.
Issue/Introduction
TIBCO Spotfire Information Services treats Oracle Functions as Stored Procedures when using the DataDirect driver for Oracle. To avoid this issue, use the driver from Oracle instead.
Feedback
Yes
No
Powered by
