i want parameters plsql proceduer.
procedure balance(requestdate in date, uniqueid in number, field1 out varchar2, field2 out varchar2) begin field1 := '110'; field2 := '100'; end balance; and java code:
javax.persistence.query query = pm.getentitymanager().createnativequery(" declare number(10);" + " b number(10);" + " begin balance(:date,:id,a,b); end;"); query.setparameter("date", transaction.gettransactionid().getrequestdate()); query.setparameter("id", transaction.gettransactionid().getid()); query.executeupdate(); i want use 'a' , 'b' in java program , don't know how 'a' , 'b'? thanks.
actually don't need hibernate jdbc. don't have aany entity out params.
to call them register ut parameters , them after calling statement.
string getdbuserbyuseridsql = "{call getdbuserbyuserid(?,?,?,?)}"; callablestatement = dbconnection.preparecall(getdbuserbyuseridsql); callablestatement.setint(1, 10); callablestatement.registeroutparameter(2, java.sql.types.varchar); callablestatement.registeroutparameter(3, java.sql.types.varchar); callablestatement.registeroutparameter(4, java.sql.types.date); // execute getdbuserbyuserid store procedure callablestatement.executeupdate(); string username = callablestatement.getstring(2); string createdby = callablestatement.getstring(3); date createddate = callablestatement.getdate(4); the code the example
