Kbase P111076: Oracle DataServer Returns Error 1003 ** no statement parsed
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/11/2005 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
ORACLE error see "ORACLE Error Messages and Codes Manual". (1252)
ORACLE error -1003 see "ORACLE Error Messages and Codes Manual". (1252)
** no statement parsed
Stored procedure is used to run SQL statement on Oracle.
ALTER INDEX <index name> REBUILD ONLINE PARAMETERS('sync')
CAUSE:
Multiple users running ALTER INDEX on the same record simultaneously.
FIX:
Instead of ALTER INDEX use:
begin ctx_ddl.sync_index('<index name>'); end;