是不是authid子句哪里用错了，运行显示警告: 创建的函数带有编译错误

[haiwenlin]

create or replace function mypi
authid current_user as
begin
NULL;
return 3.14;
end;
/
运行时显示
警告: 创建的函数带有编译错误
大家看看错 在哪里，就这两三行代码

[more_zou]

show error

[haiwenlin]

show error 后如下：
FUNCTION MYPI 出现错误:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/1 PLS-00103: 出现符号 "AUTHID"在需要下列之一时：
(returncompresscompiled
wrapped
符号 "return在 "AUTHID" 继续之前已插入。

[haiwenlin]

2/1 PLS-00103: 出现符号 "AUTHID"在需要下列之一时：
(returncompresscompiled
wrapped
符号 "return在 "AUTHID" 继续之前已插入。
我在oracle 9i环境下，这种错误提示信息好像看不是很明白，书上说可以参考oracle帮助，不知哪位也是oracle9i 中文版的，帮助哪里查看啊

[beckhambobo]

语法已经有问题了,请看以下说明:
invoker_rights_clause
The invoker_rights_clause lets you specify whether the function executes with the privileges and in the schema of the user who owns it or with the privileges and in the schema of CURRENT_USER.

This clause also determines how Oracle resolves external names in queries, DML operations, and dynamic SQL statements in the function.

AUTHID CURRENT_USER
Specify CURRENT_USER if you want the function to execute with the privileges of CURRENT_USER. This clause creates an "invoker-rights function."

This clause also specifies that external names in queries, DML operations, and dynamic SQL statements resolve in the schema of CURRENT_USER. External names in all other statements resolve in the schema in which the function resides.

AUTHID DEFINER
Specify DEFINER if you want the function to execute with the privileges of the owner of the schema in which the function resides, and that external names resolve in the schema where the function resides. This is the default.

你的语句没有返回值.

[beckhambobo]

SQL> create or replace function mypi
2 return number authid current_user as
3 begin
4 return 3.14;
5 end;
6 /

Function created

SQL> select mypi from dual;

MYPI
----------
3.14

[haiwenlin]

beckhambobo(beckham)，你哪里搞来那一串说明啊，跟我说说行吗，以后碰到问题我也可以去查啊

[haiwenlin]

已经结贴