Hiya, can anyone recommand a few dbms programs like dbartisan for oracle database? Basically I just want a nice gui that shows me all the tables and store procedures a particule database has. I tried to search the net but not quite sure what to look for. And DBArtisan is too expensive.
On another note I keep getting-"sql.SQLEXCEPTION: Use executeUpdate instead of executeQuery"
The general code is
....
CallableStatement cs = con.prepareCall("{call SOME_FUNCTION(?)}");
cs.setString(1,"USER_ID");
ResultSet rs = cs.executeQuery();
....
When I run the SOME_FUNCTION('USER_ID') in a simple msquery it returns 5 columns with about 100 rows of data. So i dont see why it's not a query. It doesnt store the USER_ID or modify the database in any way. And I dont know how to look at the store procedure codes, hence the reason i am looking for a dbms
Any help will be greatly appreciated, thank you!
Bo