code below
CallableStatement cs = getDataSource().getConnection().prepareCall("{call RECEIVE_CHARGE(?,?,?,?,?,?,?)}");
int i=1;
cs.setString(i++,strdate );
cs.setString(i++, vo.getOperator());
cs.setString(i++, "2014");
cs.setString(i++, "2013-11-15");
cs.setString(i++, "2014-3-15");
cs.setInt(i++, 1);
cs.setString(i++, vo.getHousecode());
cs.execute();
getDataSource().getConnection().close();
this case, the background has been an error saying that receives less than a third parameter which is why 2014 ? seeking solutions
------ Solution ----------------------------------- ---------
Why to i + +? ? ? Direct 12345 not do
------ Solution --------------- -----------------------------
inspection affairs , in other affairs retrieval .
------ For reference only -------------------------------------- -
Why to i + +? ? ? Direct 12345 not do
effect should be the same , right ?
------ For reference only ------------------------------------ ---
Why to i + +? ? ? Direct 12345 not do
write 12345 This is the same error message does not receive parameters
------ For reference only ------------------- --------------------
Why to i + +? ? ? Direct 12345 not do 12345
write the same mistake this is reported not receive parameters
stickers out of the stored procedure does
------ For reference only -------------------------- -------------
Why to i + +? ? ? Direct 12345 not do 12345
write the same mistake this is reported not receive parameters
stickers out of the stored procedure does
stored procedure is not the problem directly in the plsql another place in the test and no problem calling it called at the time on this error
------ for reference only ---------------------------------------
the procedure of iN parameters To Come posted
------ For reference only ------------------------------- --------
create or replace procedure receive_charge(
czsj in varchar2,
czr in varchar2,
sfnd in varchar2,
startdate in varchar2,
enddate in varchar2,
countcus in varchar2,
usercode in varchar2
)
as
cursor c_infor is
------ For reference only ----------------------------------- ----
seeking reply ... Why is there such a situation
没有评论:
发表评论