Someone would need to modify the JDBC adapter so that if it connects to Oracle it would interrogate Oracle’s catalog to find the UDFs in Oracle. I don’t know if there’s a way to find UDFs generically (i.e. that relies only on JDBC, not knowing what flavor of database you are connecting to).
> On Jul 20, 2018, at 12:54 AM, Stamatis Zampetakis <[email protected]> wrote: > > Hello Subbarao, > > I am not sure, I understand what you want to achieve. > > I suppose you are using the JdbcSchema (directly or indirectly), most > likely through the JDBC Adapter. > If that's the case then probably the reason that you don't see the > user-defined functions is that the getFunctions() method is not yet > implemented. > > Best, > Stamatis > > 2018-07-12 7:12 GMT+02:00 subbarao mitta <[email protected]>: > >> Hi how to add existing user defined functions in Oracle database to schema >> in calcite.I am connected Oracle database using schema but I don't know how >> to add existing user defined functions to schema. >>
