Kbase P42972: Erreur ORA-01003 on CREATE
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
ORA-01003: no statement parsed
Error when creating a record in the table "ADM.EAKR", when logged as user 'userX' different from "ADM"
No problem for userX to create (insert) records into ADM.EAKR from sql*plus
No problem for userX to update records into ADM.EAKR from Progress
Last statement within dataserv.lg (connected with "-Dsrv qt_debug,EXTENDED"):
SELECT ADM.EAKR_seq.nextval FROM sys.dual
CAUSE:
Following statement run by 'userX' from sql*plus
SELECT ADM.EAKR_seq.nextval FROM sys.dual
results in an error showing a permission problem
FIX:
Run
grant SELECT on ADM.EAKR_seq to userX;
within Oracle.