语句
create or replace procedure a1 as
begin
select * from aladdinagent_dicinfo;
end;
错误提示
pls:在此Select语句中缺少INTO子句
PL SQL:Statement ignore
------解决方法--------------------------------------------------------
select * from aladdinagent_dicinfo;必须要into..
不能像sql server那样返回数据
------解决方法--------------------------------------------------------
create or replace procedure a1(aaa out varchar2)
as
begin
select a into aaa from aladdinagent_dicinfo;
end;
------解决方法--------------------------------------------------------
按照你的想法你的存储过程应该这样写
create or replace package aaa
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;
