I'm not sure if this is implemented by Oracle, but there is DatabaseMetaData#getFunctions.
https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getFunctions(java.lang.String,%20java.lang.String,%20java.lang.String) -- Michael Mior [email protected] Le ven. 20 juil. 2018 à 14:11, Julian Hyde <[email protected]> a écrit : > > 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. > >> >
