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
Post a Comment