Kbase P22616: Session ends as soon as querying Oracle database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
Windows NT 32 Intel/Windows 2000
SYMPTOM(s):
Session ends as soon as querying Oracle database
Querying tables from sqlplus works
Connection to Oracle using Net8
Dataserv.lg shows no error but no further entry after, for example, the following:
SELECT /*+ INDEX_ASC(T0 tableX##indexY) */ ROWID unique_id_0 FROM userN.tableX T0
Same queries run fine from other Win32 platforms
Running a migration from Progress to Oracle (protoora) showed error 10000
in dataserv.lg
SYSTEM ERROR: ORACLE erreur de Commit -10000 (1476)
FIX:
Set ORACLE_HOME with the path of the Oracle version you need to use.