ORA-900 invalid sql statement error while calling optimize_index procedure from pl/sql
Hi Experts,
I am on Oracle 11.2.0.3 on Linux and have Oracle Text installed in my database. I want to set up dbms_job schedule to optimize my oracle text indexes. So first I created a pl/sql procedure to optimize the indexes. (By the way, the CTXAPP role has been granted to the schema in which I created the indexes and running this procedure.) But it is giving me ORA-900 error, but the same sql if I run from sqlplus it works fine! Can you please help me find what the issue is:
I am on Oracle 11.2.0.3 on Linux and have Oracle Text installed in my database. I want to set up dbms_job schedule to optimize my oracle text indexes. So first I created a pl/sql procedure to optimize the indexes. (By the way, the CTXAPP role has been granted to the schema in which I created the indexes and running this procedure.) But it is giving me ORA-900 error, but the same sql if I run from sqlplus it works fine! Can you please help me find what the issue is:
Here is the procedure:
CREATE OR REPLACE PROCEDURE optimize_ora_txt_indexes_debug
0