Access Violation

[Peter Butler]

I am getting an access violation error on columns that are defined as sys.xmltpe in Oracle 9.2.0.4.0.

It allows me to create a SQL query to select * from ?? and it works the first time. The secon time that i run the same query without making any changes (eg no editing) i get the following error.

Access violation at address 01F5E7C1 in module 'orageneric10.dll'. Write of address 00000000.

Any ideas or suggestions would be appreciated.

My system details are as follows

PL/SQL Developer
Version 6.0.0.840 (MBCS)
02.16318 - 20 user license
Windows XP version 6.0 (build 2600) Service Pack 2

Physical memory : 491,040 kB (56,000 available)
Paging file : 1,148,796 kB (778,020 available)
Virtual memory : 2,097,024 kB (2,023,708 available)

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

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

Plug-Ins

Homes
Oracle10gClient (C:\Oracle10gClient)

DLLs
C:\Oracle10gClient\bin\oci.dll

TNS File
C:\Oracle10gClient\Network\Admin\tnsnames.ora

Using
Home: Oracle10gClient
DLL: C:\Oracle10gClient\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.4.0
Character size: 1 byte(s)

 

[Marco Kalter]

Can you upgrade to PL/SQL Developer 6.0.3 and try again?

 

[Peter Butler]

I have noticed that a workaround is to update the SQL and remove it returning the data as .getclobval() to .getStringval()

I will upgrade to the above version.

 

[Peter Butler]

I have upgraded to latest version and the error still occurrs.

PL/SQL Developer
Version 6.0.3.893 (MBCS)
02.16318 - 20 user license
Windows XP version 6.0 (build 2600) Service Pack 2

Physical memory : 491,040 kB (149,620 available)
Paging file : 1,148,796 kB (743,944 available)
Virtual memory : 2,097,024 kB (2,022,624 available)

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

Preferences
Session mode: Multi
OCI Library: C:\Oracle10gClient\bin\oci.dll
Use OCI7: False

Plug-Ins

Homes
Oracle10gClient (C:\Oracle10gClient)

DLLs
C:\Oracle10gClient\bin\oci.dll

TNS File
C:\Oracle10gClient\Network\Admin\tnsnames.ora

Using
Home: Oracle10gClient
DLL: C:\Oracle10gClient\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.4.0
Character size: 1 byte(s)

 

[Marco Kalter]

I cannot immediately reproduce this, but we'll look into it.