create or replace function f_get_ids(p_user in nvarchar2)
return nvarchar2 sql_macro(table)
as
begin
return q'[select id from table1 where user=p_user]';
end;
while executing the above code in oracle 19.0.0.0.0 version getting the below error.
Error(1,27): PLS-00103: Encountered the symbol "(" when expecting one of the following: ; is default authid as cluster order using external deterministic parallel_enable pipelined aggregate result_cache accessible rewrite
Copyright Notice:Content Author:「Xyz」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/71114808/compilation-error-for-sql-macro-in-oracle-19c