executequery() with db defined from admin console

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 VARCHAR
IS
BEGIN
return '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