TIBCO Spotfire Information Services treats Oracle Functions as Stored Procedures when using the DataDirect driver for Oracle

TIBCO Spotfire Information Services treats Oracle Functions as Stored Procedures when using the DataDirect driver for Oracle

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) } The only way to correct this behavior is to create the information model using the Oracle Thin driver connection.