我的存储过程是
CREATE procedure st_buyitem
as
begin
set nocount on
select * into #t1 from OPENQUERY(bcs,'
Select
trim(t$item) item,
trim(t$dsca) dsca
From BAAN.ttcibd001110@BAAN26 where t$citg=''M10801'' ')
insert into buy(item,dsca)
select item,dsca from #t1
--set nocount off
end
drop table #t1
GO在Delphi中用的时候是
procedure Tfbuy.SpeedButton1Click(Sender: TObject);
begin
with erp do
begin
connection:=dm.ADOCerp;
parameters.Clear;
procedurename:='st_buyitem';
ExecProc;
end;
end;
可是错误是
ORA-06550: 第 1 行, 第 7 列:
PLS-00201: 必须说明标识符 ‘st_buyitem’
PL/SQL: Statement ignored 请高手指教
CREATE procedure st_buyitem
as
begin
set nocount on
select * into #t1 from OPENQUERY(bcs,'
Select
trim(t$item) item,
trim(t$dsca) dsca
From BAAN.ttcibd001110@BAAN26 where t$citg=''M10801'' ')
insert into buy(item,dsca)
select item,dsca from #t1
--set nocount off
end
drop table #t1
GO在Delphi中用的时候是
procedure Tfbuy.SpeedButton1Click(Sender: TObject);
begin
with erp do
begin
connection:=dm.ADOCerp;
parameters.Clear;
procedurename:='st_buyitem';
ExecProc;
end;
end;
可是错误是
ORA-06550: 第 1 行, 第 7 列:
PLS-00201: 必须说明标识符 ‘st_buyitem’
PL/SQL: Statement ignored 请高手指教
存储过程: cs.dbo.st_buyitem
返回代码 = 0对不