According to the documentation of the plsql_function_source
the following statement should work:
create or replace function f1 (in_p1 in integer) return integer sharing = none is
begin
return 1;
end;
/
But it produces a PLS-00103: Encountered the symbol "SHARING" when expecting one of the following: ….
The reason is a documentation bug. The sharing_clause must be placed after the function_name.
The following statement works:
create or replace function f1 sharing = none (in_p1 in integer) return integer is
begin
return 1;
end;
/