Hi all,
we have a requirement to execute an oracle function on a Sail interface.
We have the following function
create or replace FUNCTION TEST_APPIAN return VARCHARISBEGINreturn '0';END TEST_APPIAN;
If a use this function on a db defined in the "old" way (the xsd in the deployments folder) it work with the following sail code:
executequery( datasource: "java:/jdbc/Predict",query: "SELECT DISTINCT PREDICT.TEST_APPIAN() AS PIPPO FROM DUAL")
and the result is 0.
But if i try to exceute the same function from a db defined in the "new" way (from the admin console) it doesent't work even if i substitute the datasource with "jdbc/Predict"
Some suggestions?
Discussion posts and replies are publicly visible