Win a copy of The Business Blockchain this week in the Cloud forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

oracle-jdbc problem and a dbms question

 
bo shen
Greenhorn
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(?)}");
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic