Access violation

[oscarvf]

when executing a query:
select * from error
show message:
"Access violation at address 612D7D61 in module 'oranls10.dll'. Read of address 03F5C000"

After this, I cannot close the SQL Window or close the application.

But in SQL PLus query successful!!!

What gives?

 

[oscarvf]

info:

--- Info ---

PL/SQL Developer
Version 6.0.5.931 (MBCS)
66.18856 - Unlimited user license
Windows 2000 version 5,0 (build 2195) Service Pack 4

Physical memory : 515,568 kB (182,144 available)
Paging file : 3,555,952 kB (3,243,452 available)
Virtual memory : 2,097,024 kB (1,980,272 available)

Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Plug-Ins

Aliases
CDBPNET
CDBPNET_130.1.22.75
DBPNET

Homes
OraClient10g (C:\Oracle\product\10.1.0\Client_1)

DLLs
C:\Oracle\product\10.1.0\Client_1\bin\oci.dll

TNS File
C:\Oracle\product\10.1.0\Client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient10g
DLL: C:\Oracle\product\10.1.0\Client_1\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0
Character size: 1 byte(s)

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
VOBHOME2.0 = C:\Oracle\product\10.1.0\Client_1

SOFTWARE\ORACLE\KEY_Home1
ORACLE_HOME = C:\OraHome_1
ORACLE_HOME_NAME = Home1
ORACLE_GROUP_NAME = Oracle - Home1

SOFTWARE\ORACLE\KEY_OraClient10g
ORACLE_HOME = C:\Oracle\product\10.1.0\Client_1
ORACLE_HOME_NAME = OraClient10g
ORACLE_GROUP_NAME = Oracle - OraClient10g
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
OLEDB = C:\Oracle\product\10.1.0\Client_1\oledb\mesg
SQLPATH = C:\Oracle\product\10.1.0\Client_1\dbs
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient10g
OO4O = C:\Oracle\product\10.1.0\Client_1\oo4o\mesg
MSHELP_TOOLS = C:\Oracle\product\10.1.0\Client_1\MSHELP

SOFTWARE\ORACLE\KEY_OraClient10g\ODP.NET
TraceFileName = C:\ODPNET.trc
TraceLevel = 0
TraceOption = 0

SOFTWARE\ORACLE\KEY_OraClient10g\OLEDB
CacheType = Memory
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0

SOFTWARE\ORACLE\KEY_OraClient10g\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\Oracle\product\10.1.0\Client_1\oo4o\doc\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\Oracle\product\10.1.0\Client_1\oo4o

SOFTWARE\ORACLE\KEY_OraDb10g_home1
ORACLE_HOME = C:\oracle\product\10.1.0\Db_2
ORACLE_HOME_NAME = OraDb10g_home1
ORACLE_GROUP_NAME = Oracle - OraDb10g_home1

SOFTWARE\ORACLE\SCR

SOFTWARE\ORACLE\SYSMAN

SOFTWARE\ORACLE\Workflow
Icon Directory = C:\Oracle\product\10.1.0\Client_1\WF\ICON
Level = d Version = 2.6.3.0.0
Developer Mode = Instance Label =
Internal Name = Display Comment = Display Name = Display Performer =
SOFTWARE\ORACLE\Workflow\Font

SOFTWARE\ORACLE\Workflow\Languages

--- Path ---

C:\Oracle\product\10.1.0\Client_1\bin
C:\Oracle\product\10.1.0\Client_1\jre\1.4.2\bin\client
C:\Oracle\product\10.1.0\Client_1\jre\1.4.2\bin
C:\IBM\WebSphere MQ\Java\lib
C:\Program Files\CA\pec\bin
C:\WINNT\system32
C:\WINNT
C:\WINNT\System32\Wbem
C:\Program Files\Microsoft SQL Server\80\Tools\BINN
C:\Program Files\CA\CCC_Harvest
C:\SNA\system
C:\IBM\WebSphere MQ\WEMPS\bin
C:\IBM\WebSphere MQ\bin
C:\IBM\WebSphere MQ\tools\c\samples\bin
C:\LINGO9\
C:\Lindoapi\bin\win32
C:\SQLLIB\BIN
C:\SQLLIB\SAMPLES\REPL
C:\SQLLIB\HELP
C:\IMNNQ_NT
C:\Program Files\Microsoft Visual Studio\VC98\Bin
C:\Program Files\Microsoft Visual Studio\Common\MSDev98\Bin
C:\Program Files\SSH Communications Security\SSH Secure Shell

--- TNS names ---

# tnsnames.ora Network Configuration File: C:\Oracle\product\10.1.0\Client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

CDBPNET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.1.22.243)(PORT = 5560))
)
(CONNECT_DATA =
(SID = CDBPNET)
(SERVER = DEDICATED)
)
)

DBPNET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.1.22.243)(PORT = 5560))
)
(CONNECT_DATA =
(SID = DBPNET)
(SERVER = DEDICATED)
)
)

CDBPNET_130.1.22.75 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.1.22.75)(PORT = 5560))
)
(CONNECT_DATA =
(SID = CDBPNET)
(SERVER = DEDICATED)
)
)

 

[Marco Kalter]

Can you send me the table definition?

 

[oscarvf]

ok:

CREATE TABLE ERROR (
CHRCODIGOINTERNO CHAR(8) NULL,
CHRCODIGOERROR CHAR(7) NOT NULL,
VCHMENSAJEREAL VARCHAR2(500) NULL,
VCHMENSAJEUSUARIO VARCHAR2(500) NULL,
CHRCODIGOSEVERIDAD CHAR(6) NULL,
CHRTIPO CHAR(6) NULL,
CHRPAGINA VARCHAR2(70) NULL,
CHRURL VARCHAR2(120) NULL
);

ALTER TABLE ERROR
ADD ( PRIMARY KEY (CHRCODIGOINTERNO) ) ;