Hi Team,
I am creating the Compile invalid object application using Oracle Apex. I am using the below pl/sql block.Here the :P5_STANDARD_ENV value call from apex page i.e VMWTST15 (env based which means dynamic ) user can choose the different environment for compiling the invalid objects from front end.I have created the db link for calling the target database name is
SQL> declare
p_env_name varchar2(80);
begin
p_env_name :='VMWTST15'; --(directly i have passed the envname)
dbms_output.put_line(p_env_name);
--sys.UTL_RECOMP.recomp_parallel@VEPS_TO_||p_env_name;--- commented
end;
/
Output :
--------------
VMWTST15
PL/SQL procedure successfully completed.
SQL> declare
p_env_name varchar2(80);
begin
p_env_name :='VMWTST15'; --(directly i have passed the envname)
dbms_output.put_line(p_env_name);
sys.UTL_RECOMP.recomp_parallel@VEPS_TO_||p_env_name; -- uncommented
end;
/
Getting the below error:
sys.UTL_RECOMP.recomp_parallel@VEPS_TO_||p_env_name;
*
ERROR at line 7:
ORA-06550: line 7, column 40:
PLS-00103: Encountered the symbol "|" when expecting one of the following:
. ( @ ;
The symbol ". was inserted before "|" to continue.
Please help me to fix this issues.
Thanks,
Dhayalan V