此问题总是不能解决,执行时总报ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'TEST'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
调用程序如下:
with DataModuleForm.ADOStoredProc1 do
begin
Close;
Connection:=DataModuleForm.ADOConnection;
Parameters.Clear;
ProcedureName:= 'test1.test';
Parameters.CreateParameter('in1',ftDate,pdInput,8,DateTimePicker1.Date);
Parameters.CreateParameter('in2',ftString,pdInput,8,ComboBox1.Text);
Parameters.CreateParameter('in3',ftString,pdInput,8,Edit1.Text);
Parameters.CreateParameter('in4',ftString,pdInput,8,Edit2.Text);
Parameters.CreateParameter('in5',ftString,pdInput,8,Edit3.Text);
try
ExecProc;
except
showmessage('执行存储过程失败!');
end;
end;存储过程为
TYPE rc_class IS REF CURSOR RETURN table1%ROWTYPE;
CREATE OR REPLACE PACKAGE BODY test1 AS
PROCEDURE test( --
in1 IN DATE, --
in2 IN VARCHAR2,
in3 IN VARCHAR2,
in4 IN VARCHAR2,
in5 IN VARCHAR2,
ResultCursor out rc_class)
IS
BEGIN
OPEN ResultCursor FOR SELECT * FROM table;
END test;END test1;
PLS-00306: wrong number or types of arguments in call to 'TEST'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
调用程序如下:
with DataModuleForm.ADOStoredProc1 do
begin
Close;
Connection:=DataModuleForm.ADOConnection;
Parameters.Clear;
ProcedureName:= 'test1.test';
Parameters.CreateParameter('in1',ftDate,pdInput,8,DateTimePicker1.Date);
Parameters.CreateParameter('in2',ftString,pdInput,8,ComboBox1.Text);
Parameters.CreateParameter('in3',ftString,pdInput,8,Edit1.Text);
Parameters.CreateParameter('in4',ftString,pdInput,8,Edit2.Text);
Parameters.CreateParameter('in5',ftString,pdInput,8,Edit3.Text);
try
ExecProc;
except
showmessage('执行存储过程失败!');
end;
end;存储过程为
TYPE rc_class IS REF CURSOR RETURN table1%ROWTYPE;
CREATE OR REPLACE PACKAGE BODY test1 AS
PROCEDURE test( --
in1 IN DATE, --
in2 IN VARCHAR2,
in3 IN VARCHAR2,
in4 IN VARCHAR2,
in5 IN VARCHAR2,
ResultCursor out rc_class)
IS
BEGIN
OPEN ResultCursor FOR SELECT * FROM table;
END test;END test1;
解决方案 »
- 求教动态创建mscomm的使用方法
- 日期灾民比较?
- ***在DBGrideh中有个字段设成CheckBoxes,怎样做能使在编辑时,鼠标点一条记录的checkbox字段为True,其它字段自动更新为False,而且指针还停
- Listview下如何刷新数据
- 关于ShockwaveFlash的简单问题!!!!!!!!!
- 自己设计VCL组件时,怎样定义对象类型的属性 ?
- delphi7中怎么没有TClientSocket和TServerSocket?
- 难题·如何做成QQ那种啊?
- 关于登陆窗口问题
- abde00(为了讨老婆喜欢,努力学习中......)进来领分
- 为何在WinXP中无法跟踪调试COM+?
- 如何用INI文件 快速保存控件的值和从INI中 读取值再赋给 控件?
oracle的语法看不懂
用Open; 或Active:=True;