运行如下SQL时没有问题
SELECT ACTION FROM V$SESSION WEHRE AUDSID = USERENV('SESSIONID')
现建立如下存储过程则报错:ORA-00942 表或视图不存在。CREATE OR REPLACE PROCEDURE PRC_COM_SESINFO_GET (
p_ptruser OUT VARCHAR2 -- USERID
) AS
p_insert_user VARCHAR2(64); -- ACTION
BEGIN
-- 取得SESSION信息
SELECT
ACTION
INTO
p_insert_user
FROM
V$SESSION
WHERE
AUDSID = USERENV('SESSIONID');
-- 生成返回值
p_ptruser := p_insert_user;
IF (p_ptruser IS NULL) THEN
p_ptruser := 'NONE';
END IF;
END PRC_COM_SESINFO_GET;
/
请指点!!谢谢
SELECT ACTION FROM V$SESSION WEHRE AUDSID = USERENV('SESSIONID')
现建立如下存储过程则报错:ORA-00942 表或视图不存在。CREATE OR REPLACE PROCEDURE PRC_COM_SESINFO_GET (
p_ptruser OUT VARCHAR2 -- USERID
) AS
p_insert_user VARCHAR2(64); -- ACTION
BEGIN
-- 取得SESSION信息
SELECT
ACTION
INTO
p_insert_user
FROM
V$SESSION
WHERE
AUDSID = USERENV('SESSIONID');
-- 生成返回值
p_ptruser := p_insert_user;
IF (p_ptruser IS NULL) THEN
p_ptruser := 'NONE';
END IF;
END PRC_COM_SESINFO_GET;
/
请指点!!谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货