Z
zybzhen
Unregistered / Unconfirmed
GUEST, unregistred user!
我的oracle存储过程,oracle 9<br>create or replace procedure getLogRows( <br> in_srq in VARCHAR2,in_erq in VARCHAR2, <br> out_sage out NUMBER <br>) <br>is <br>begin <br> select <br> count(*) into out_sage <br> from Logs <br> where LogTime > to_Date(in_srq,'yyyy-mm-dd') and LogTime < to_Date(in_erq,'yyyy-mm-dd'); <br>return; <br>end getLogRows;<br>我的delphi代码:<br>adostoredproc1.Prepared := false;<br>adostoredproc1.Parameters.ParamByName('in_srq').Value := '2008-01-01';<br>adostoredproc1.Parameters.ParamByName('in_erq').Value := '2008-03-30';<br>adostoredproc1.Prepared := true;<br>adostoredproc1.ExecProc;<br><br>请指教我该怎么 获得 返回值 ?