Hi. I receive this message when I try to call a procedure that synchronize the text indexes.
CREATE OR REPLACE PROCEDURE SYNC_TEXT_INDEXES IS
ctx_ddl.sync_index( idx_name => 'CLI_NOMBRE_NDX');
ctx_ddl.sync_index( idx_name => 'CLI_RAZON_SOCIAL_NDX');
This procedure run ok when I execute it since SQLPLUS with "exec sync_text_indexes", But it doesn't run ok when I call it since others applications, like TOAD with "call sync_text_indexes" or since a program in Visual Basic.
I receive the message:
ORA-06576: not a valid function or procedure name