I need to get only the procedures using java DatabaseMetaData but this method returns also the functions' names.
DatabaseMetaData dbmd=con.getMetaData();
ResultSet result = dbmd.getProcedures(null, Ousername, null);
Asked
Active
Viewed 195 times
5
gtzinos
- 1,205
- 15
- 27
-
I have the same question. – SteveL May 17 '15 at 14:28
-
This may behave differently depending on the specific DBMS driver. Which one are you using, @gtzinos and @SteveL? – ericbn May 17 '15 at 14:35
-
@ericbn ,we are both using oracle but the same happens in postgresql too. – SteveL May 17 '15 at 14:36
-
@gtzinos Two questions: 2) Do you only need this on an Oracle Database? 2) Do you have to use `DatabaseMetaData` ? – Stefan Ferstl May 17 '15 at 14:40
-
@StefanFerstl Yes only using Database metadata – gtzinos May 17 '15 at 16:29
1 Answers
7
That happens because procedures and functions are basically the same in Oracle.
There is a column PROCEDURE_TYPE of the type short that will show the kind of procedure:
1means there is no result, so it is a procedure.2means it returns a result, so it is a function.
You can access that column as usual from the ResultSet:
result.getShort("PROCEDURE_TYPE")
