• Post Reply Bookmark Topic Watch Topic
  • New Topic

oracle-jdbc problem and a dbms question  RSS feed

Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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(?)}");
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!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!