Question

delphi调用Oracle存储过程，提示列不存在错误！

create or replace procedure aaaaa1 (
p_user_id_i in varchar2,
o_cur out sys_refcursor
)
as
begin
open o_cur for select * from emp where emp.empno = p_user_id_i;
end aaaaa1;
ADOQuery1.Close;
ADOQuery1.Parameters.Clear;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('{call aaaaa1(?)}');
ADOQuery1.Parameters.CreateParameter('p_user_id_i',ftString,pdInput,255,NULL);

ADOQuery1.Parameters.ParamByName('p_user_id_i').Value:='7369';
ADOQuery1.ExecSQL;
open也不行，烦！
之前在PL/SQL Developer的SQL窗口调用call aaaaa1('7369');可以运行，现在提示错误：ORA-06553: PLS-306: wrong number or types of arguments in call to 'AAAAA1'

Answer 1

用adostoredproc控件，不要用adoquery。

Answer 2

用adostoredproc控件，那是个存储过程

Answer 3

不要用adoquery