把ForumID in number, Rolename in nvarchar2参数名字改成别的名字试试!
解决方案 »
- unix下oracle11g临时表空间信息
- 创建临时表的权限问题,急
- ORALCE不定期死机起不来
- Oracle 数据分析产品的疑惑 高分求解惑
- 求:在HP-UX下ORACLE9i的安装步骤
- 新装的oracle我想配置监听程序,发现的1521端口已经被另外一个TNSLSNR.exe占用,为什么?怎么办?
- plsql联oracle92报错:Error while trying to retrive text for error ORA-01019
- 重启机器后oracle实例不能自动重启
- 一个导入/导出的问题?
- 大家来看看怎么解决这个问题
- 为何不能进入oracle mangment server?
- ORACLE数据库里的WHERE语句中的条件句执行问题
is
begin
IF NOT EXISTS (SELECT ForumID FROM PrivateForums WHERE ForumID=inForumID AND Rolename=inRolename) AND
EXISTS (SELECT ForumID FROM Forums WHERE ForumID=inForumID) AND
EXISTS (SELECT Rolename FROM UserRoles WHERE Rolename=inRolename)
THEN
INSERT INTO
PrivateForums(ForumID, RoleName)
VALUES
(inForumID, inRolename);
END IF;
end forums_AddForumToRole;
提示错误
Compilation errors for PROCEDURE SYSTEM.FORUMS_ADDFORUMTOROLEError: PLS-00204: 函数或伪列 'EXISTS' 只能在 SQL 语句中使用
Line: 4
Text: IF NOT EXISTS (SELECT ForumID FROM PrivateForums WHERE ForumID=inForumID AND Rolename=inRolename) ANDError: PL/SQL: Statement ignored
Line: 4
Text: IF NOT EXISTS (SELECT ForumID FROM PrivateForums WHERE ForumID=inForumID AND Rolename=inRolename) AND