Z
zy510007
Unregistered / Unconfirmed
GUEST, unregistred user!
Oracle817升级为10g后存储过程在数据库中测试成功,但是在Delphi7中调用出错。<br>简单例子:<br>CREATE OR REPLACE PROCEDURE "GETPLANID" (Ret out varchar2) IS<br>begin<br> select trim(to_char(sysdate, 'yymm'))||trim(to_char(shopseq.nextVal, '0000000')) into ret from dual;<br>end;<br>调用:<br>sspGETPLANID.ExecProc;<br>test1.Text := sspGETPLANID.Params.ParamValues['ret']<br>以上调用在Oracle817版本测试成功,在升级后报错“参数类型或数量错误”。<br>请各位高人指点一二,不胜感激!