语句
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;