CREATE OR REPLACE PACKAGE pkg_test
AS
TYPE myrctype IS REF CURSOR;
END pkg_test;
/
create or replace PROCEDURE get(p_rc OUT pkg_test.myrctype)
IS
sqlstr VARCHAR2 (50);
BEGIN
sqlstr:='select * from aa';
OPEN p_rc FOR sqlstr;
END get;
/
procedure TForm1.Button1Click(Sender: TObject);
begin
adostoredproc1.close;
adostoredproc1.open;
label1.caption:= ADOStoredProc1.fields[1].asstring;
while not adostoredproc1.eof do
begin
label2.caption:= ADOStoredProc1.fields[1].asstring;
adostoredproc1.Next;
end;
end;
用QUERY的方法
放一个ADOQUERY,DATASOURCE,DBGRID,ADOCONNECTION,
store proc
create proc aa
as
select * form cus_tab
end
在delphi
1.create adoconnection;
2.指定QUERY的连接为ADOCONNECTION
3。在QUERY的SQL中写入
exec aa
4.query.active:=true;
5.datasource.dataset:=adoquery;
6.dbgrid.datasource:=datasource;
这样就可以了呀,你是哪遇到问题了?