constantly getting this error on only one table.
I see nothing unusual in desc. of this table.
but for some reason it ( developer ) is crashing while selecting data from it.
It doens't matter if i use "comand window" or "sql" window.
sometimes it comes back with data and then crashes, sometimes it dies right away.
sqlplus is working properly.
SQL> desc err_log
Name Type Nullable Default Comments
--------------- -------------- -------- ------- --------
ID_LOG NUMBER
ID_SESSION VARCHAR2(32)
ID_PRSN NUMBER Y
TS_CR DATE
TOPIC_NAME VARCHAR2(50) Y
ERROR_MSG VARCHAR2(4000) Y
ERROR_EXCEPTION VARCHAR2(4000) Y
----
PL/SQL Developer
Version 6.0.3.893 (MBCS)
Windows XP version 6.0 (build 2600) Service Pack 1
Physical memory : 2,096,360 kB (1,659,948 available)
Paging file : 4,038,756 kB (3,791,424 available)
Virtual memory : 2,097,024 kB (2,030,108 available)
Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe
Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Plug-Ins
Homes
OraDb10g_home1 (C:\oracle\product\10.1.0\db_1)
DLLs
C:\oracle\product\10.1.0\db_1\bin\oci.dll
TNS File
C:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\tnsnames.ora
Using
Home: OraDb10g_home1
DLL: C:\oracle\product\10.1.0\db_1\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
Character size: 1 byte(s)
--- end -----
I see nothing unusual in desc. of this table.
but for some reason it ( developer ) is crashing while selecting data from it.
It doens't matter if i use "comand window" or "sql" window.
sometimes it comes back with data and then crashes, sometimes it dies right away.
sqlplus is working properly.
SQL> desc err_log
Name Type Nullable Default Comments
--------------- -------------- -------- ------- --------
ID_LOG NUMBER
ID_SESSION VARCHAR2(32)
ID_PRSN NUMBER Y
TS_CR DATE
TOPIC_NAME VARCHAR2(50) Y
ERROR_MSG VARCHAR2(4000) Y
ERROR_EXCEPTION VARCHAR2(4000) Y
----
PL/SQL Developer
Version 6.0.3.893 (MBCS)
Windows XP version 6.0 (build 2600) Service Pack 1
Physical memory : 2,096,360 kB (1,659,948 available)
Paging file : 4,038,756 kB (3,791,424 available)
Virtual memory : 2,097,024 kB (2,030,108 available)
Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe
Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Plug-Ins
Homes
OraDb10g_home1 (C:\oracle\product\10.1.0\db_1)
DLLs
C:\oracle\product\10.1.0\db_1\bin\oci.dll
TNS File
C:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\tnsnames.ora
Using
Home: OraDb10g_home1
DLL: C:\oracle\product\10.1.0\db_1\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
Character size: 1 byte(s)
--- end -----