begin
execute immediate q'|
WITH
FUNCTION with_function(p_id IN NUMBER) RETURN NUMBER IS
BEGIN
RETURN p_id;
END;
SELECT with_function(1)
FROM dual
|';
end;Statement processed.
begin
execute immediate q'|
WITH
FUNCTION with_function(p_id IN NUMBER) RETURN NUMBER result_cache IS
BEGIN
RETURN p_id;
END;
SELECT with_function(1)
FROM dual
|';
end;ORA-06553: PLS-313: 'WITH_FUNCTION' not declared in this scope ORA-06512: at line 2 ORA-06512: at "SYS.DBMS_SQL", line 1721More Details: https://docs.oracle.com/error-help/db/ora-06553
select * from v$version| BANNER | CON_ID | Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production | 0 | PL/SQL Release 12.2.0.1.0 - Production | 0 | CORE 12.2.0.1.0 Production | 0 | TNS for Linux: Version 12.2.0.1.0 - Production | 0 | NLSRTL Version 12.2.0.1.0 - Production | 0 |
|---|