- Top Category > General Questions > DataSpider Servista > [DataSpider Servista] Can BOOLEAN type be used as the return value of Oracle stored functions?
Search via FAQ No.
[DataSpider Servista] Can BOOLEAN type be used as the return value of Oracle stored functions?
Can BOOLEAN type be used as the return value of Oracle stored procedures in the [Execute Stored Procedures] of Oracle Adapter?
- Category :
Answer
As the specification of Oracle JDBC driver that is being used in Oracle Adapter, it is not possible to use data type (BOOLEAN, RECORD) specific to PL/SQL as the return value.
When you use Oracle stored functions, set the type other than the data type specific to PL/SQL such as VARCHAR2.