存储过程如下:
create or replace procedure getResultDatabyid(ids in integer,rst out sys_refcursor) is
pids integer;
begin
pids:=ids;
open rst for select provinceid,province from d_province where provinceid:=pids;
end getResultDatabyid;报错:
/*
PROCEDURE MYDB.GETRESULTDATABYID 编译错误
错误:PL/SQL: ORA-00920: 无效的关系运算符
行:5
文本:open rst for select provinceid,province from d_province where provinceid:=pids;
错误:PL/SQL: SQL Statement ignored
行:5
文本:open rst for select provinceid,province from d_province where provinceid:=pids;
*/
create or replace procedure getResultDatabyid(ids in integer,rst out sys_refcursor) is
pids integer;
begin
pids:=ids;
open rst for select provinceid,province from d_province where provinceid:=pids;
end getResultDatabyid;报错:
/*
PROCEDURE MYDB.GETRESULTDATABYID 编译错误
错误:PL/SQL: ORA-00920: 无效的关系运算符
行:5
文本:open rst for select provinceid,province from d_province where provinceid:=pids;
错误:PL/SQL: SQL Statement ignored
行:5
文本:open rst for select provinceid,province from d_province where provinceid:=pids;
*/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货