Kbase 20039: Error 3144: Oracle DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/09/2008 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
You do not have sufficient permission to set sequence values. (3144)
Compiling or running a program that accesses an Oracle database through the Oracle DataServer.
CAUSE:
The error message is misleading, as the problem occurs when:
1. Setting the current-value of a sequence via Oracle DataServer.
2. Getting the current-value of a sequence from Oracle, as this is a limitation within Oracle.
The Oracle DataServer does not support setting the value of a sequence generator. Despite the message, this problem is not a privilege issue, regardless of the user logged in.
FIX:
The current-value function cannot be used unless the next-value function has been executed on the same sequence generator in the same session.