show error 后如下:
FUNCTION MYPI 出现错误:LINE/COL ERROR
-------- -----------------------------------------------------------------
2/1 PLS-00103: 出现符号 "AUTHID"在需要下列之一时:
(returncompresscompiled
wrapped
符号 "return在 "AUTHID" 继续之前已插入。
FUNCTION MYPI 出现错误:LINE/COL ERROR
-------- -----------------------------------------------------------------
2/1 PLS-00103: 出现符号 "AUTHID"在需要下列之一时:
(returncompresscompiled
wrapped
符号 "return在 "AUTHID" 继续之前已插入。
(returncompresscompiled
wrapped
符号 "return在 "AUTHID" 继续之前已插入。
我在oracle 9i环境下,这种错误提示信息好像看不是很明白,书上说可以参考oracle帮助,不知哪位也是oracle9i 中文版的,帮助哪里查看啊
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.
你的语句没有返回值.
2 return number authid current_user as
3 begin
4 return 3.14;
5 end;
6 /Function createdSQL> select mypi from dual; MYPI
----------
3.14