java - Get all trigger names from oracle -
why take empty result set row ?
resultset row = dbmd.gettables("%", "dbuser1", "%", types); while (row.next()) { system.out.println(result.getstring(1)); }
you can use code :
try { //must upper case string username="dbuser1".touppercase(); resultset row = dbmd.gettables("%", username , "%", types); while (row.next()) { //you need table name trigger name result.getstring("table_name"); } //catch errors } catch (sqlexception e) { while (e != null) { system.out.println("\n message: " + e.getmessage()); system.out.println("\n sqlstate: " + e.getsqlstate()); system.out.println("\n errorcode: " + e.geterrorcode()); e = e.getnextexception(); } }
Comments
Post a Comment