try :CREATE OR REPLACE PROCEDURE Get_Info(
status VARCHAR2(255),
active NUMBER,
AllCount OUT NUMBER,
Online OUT NUMBER,
Error OUT NUMBER)
AS
BEGIN
select AllCount := count(*) from tr_info;
select Online := count(*) from tr_info where active=active;
select Error := count(*) from tr_status where status like '%'||status||'%';
END Get_Info;
status VARCHAR2(255),
active NUMBER,
AllCount OUT NUMBER,
Online OUT NUMBER,
Error OUT NUMBER)
AS
BEGIN
select AllCount := count(*) from tr_info;
select Online := count(*) from tr_info where active=active;
select Error := count(*) from tr_status where status like '%'||status||'%';
END Get_Info;
解决方案 »
- 如何在数据库中判断 用户登录ID
- 求cnoug邀请码
- returning和return的问题
- 在ORACLE中,怎么在字段中保存图片~~~~~急~~~送分50
- ubuntu 11gr2无法跨用户启动emctl
- 如何将不重复的记录去掉
- 【求助】怎么插入“&”符号?????
- 在线等=====初学着=====oracle中的表有没有像sqlserver下标识一个字段为自动递增啊?
- 能否描述一下索引的原理,最好能介绍索引表的结构。
- 关于 oracle 的 forall 语句效率
- 将SQL-Server存储过程转换为Oracle的,谢谢大家~~~(3)
- 将SQL-Server存储过程转换为Oracle的,谢谢大家~~~(2)
Compilation errors for PROCEDURE DEV.GET_INFOError: PLS-00103: 出现符号 "STATUS"在需要下列之一时:
( ; is with authid as
cluster compress order using compiled wrapped external
deterministic parallel_enable pipelined
符号 "is" 被替换为 "STATUS" 后继续。
Line: 2
Text: status VARCHAR2(255);Error: PLS-00103: 出现符号 "NUMBER"在需要下列之一时:
:= . ( @ % ; not null
range default character
Line: 4
Text: AllCount OUT NUMBER;
(
status VARCHAR2,
active NUMBER,
AllCount OUT NUMBER,
Online OUT NUMBER,
Error OUT NUMBER)
is
BEGIN
...
CREATE OR REPLACE PROCEDURE Get_Info(
status VARCHAR2,
active NUMBER,
AllCount OUT NUMBER,
Online OUT NUMBER,
Error OUT NUMBER)
AS
BEGIN
select AllCount := count(*) from tr_info;
select Online := count(*) from tr_info where active=active;
select Error := count(*) from tr_status where status like '%'||status||'%';
END Get_Info;//--------------------------------------------错误如下Compilation errors for PROCEDURE DEV.GET_INFOError: PL/SQL: ORA-00923: 未找到要求的 FROM 关键字
Line: 9
Text: select AllCount := count(*) from tr_info;Error: PL/SQL: SQL Statement ignored
Line: 9
Text: select AllCount := count(*) from tr_info;Error: PL/SQL: ORA-00923: 未找到要求的 FROM 关键字
Line: 10
Text: select Online := count(*) from tr_info where active=active;Error: PL/SQL: SQL Statement ignored
Line: 10
Text: select Online := count(*) from tr_info where active=active;Error: PL/SQL: ORA-00923: 未找到要求的 FROM 关键字
Line: 11
Text: select Error := count(*) from tr_status where status like '%'||status||'%';Error: PL/SQL: SQL Statement ignored
Line: 11
Text: select Error := count(*) from tr_status where status like '%'||status||'%';
他未找到要求的 FROM 关键字
可我的status active AllCount Online Error 都有过定义
select count(*) into AllCount from tr_info;
select count(*) into Online from tr_info where active=active;
select count(*) into Error from tr_status where status like '%'||status||'%';
END Get_Info;
输入参数不要与列名相同
如果想同
select count(*) into Online from tr_info where active=active;
相当于查询表的所有记录数