ORA-06576: not a valid function or procedure name
ORA-06576: not a valid function or procedure name
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
BEGIN
ctx_ddl.sync_index( idx_name => 'CLI_NOMBRE_NDX');
ctx_ddl.sync_index( idx_name => 'CLI_RAZON_SOCIAL_NDX');
END;
/
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
Thanks in advance.
Fernando Gonzalez
fernando_gonzalez_franco@hotmail.com
I'm running this with the same user.
Hi. I'm running the procedure with the same user. In SQlPlus and TOAD.
But In TOAD I receive the error, and in SQlplus it runs ok.
The user is the owner of the procedure and the owner of the tables and indexes.
That user has privilegies on the ctx_ddl procedure. procedure of the user ctxsys.
Thanks.
Fernando.