sql - how to pass another database in stored procedure as a parameter in java -


I want to pass the stored procedure in Java to another database like call Sel_RptDaywiseProduction (?) How to make DIERP database in this SP Pass in Callable Statement Thank you in Java.

Edit: code from the comment

  callable location cs = con.prepareCall ("call {Sel_RptDaywiseProduction (?)}"); Cs.setString (1, "DIERP"); Results set rs1 = cs.executeQuery (); While (rs1.next ()) {System.out.println ("mat_code ="); }  


Comments

Popular posts from this blog

winforms - C# Form - Property Change -

javascript - amcharts makechart not working -

java - Algorithm negotiation fail SSH in Jenkins -