Hello, i need to get select from Oracle function by Database link in backend. I looked at the documentation, but there are only selects from tables in database, i didn't find the examples which gets information from Oracle functions. Is it possible here to get data from Oracle function? My select is this: Select stage.fgetway('test') from dual;
Like
Hello,
There is no particular example of this kind of calliing the query and it's recommended to use the entity schema query in the server-side to retrieve needed data.
As for calling the function - theoretically it's possible using the UserDefinedFunction type inside the DBExecutor executeScalar method, but the only example available is the GetRecords method from the HierarchicalRecordSelectService (that is obsolete at the moment).