I can confirm that getFunctions works at least for Oracle and Postgres. >From a quick test on Oracle, the following call returns all functions (defined in any catalog and schema).
ResultSet rs = meta.getFunctions(null, null, "%"); 2018-07-20 20:13 GMT+02:00 Michael Mior <[email protected]>: > 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. > > >> > > >
