user1创建函数访问另一数据库不能编译
濛濛 2010-08-27 01:53:48 先创建用户
drop user jk_user cascade;
create user jk_user identified by kingncyl123;
grant resource,dba,connect to database1;
取database1数据库数据
创建函数:
CREATE OR REPLACE FUNCTION "JK_USER"."GET_KSMC" (ksbh in
varchar2)
return varchar2 IS
r_s1 varchar2(20);
r_s11 varchar2(20);
begin
select xm INTO r_s1 from database1.wh_ryb where czyid='002';
if r_s1<>'张卫岩' then
begin
return '非法使用';
end;
end if;
select ksmc INTO r_s1 from database1.wh_ksb where ksid=ksbh;
return (r_s1);
end get_ksmc;
编译状态为invalid,sqlplus提示警告: 创建的函数带有编译错误。
不过把select掩掉就能创建成功,状态为valid,是什么原因呢,急,谢谢!