语句
create or replace procedure a1 as
begin
select * from aladdinagent_dicinfo;
end; 错误提示
pls:在此Select语句中缺少INTO子句
PL/SQL:Statement ignore
create or replace procedure a1 as
begin
select * from aladdinagent_dicinfo;
end; 错误提示
pls:在此Select语句中缺少INTO子句
PL/SQL:Statement ignore
不能像sql server那樣返回數據
as
begin
select a into aaa from aladdinagent_dicinfo;
end;
is
type cur is ref cursor;//定义游标
procedure a1(Rst out cur);
end aaa;
/
create or replace package body aaa
is
procedure a1(Rst out cur)
is
begin
open a1 for select * from aladdinagent_dicinfo; //这样才可以返回一个结果集
end;
end aaa;
谢谢你,创建成功
看来要丢弃SQL Server的思想了
以后还请你多多帮助