Access violation when accessing a specific table

[Raj]

Following error is reported whenever I select from a specific table in my database. It is a 10g database, i am accessing using 10g client and pl/dev version is 6.0.4.906

error reported is "Access violation at address 60508AF4 in module 'oracommon10.dll'. read Of address 0261DCBE", the program freezes and I have to use taskman to kill the program.

The table is as follows ...

SQL> desc activity_status_ref
Name                   Type           Nullable Default Comments
---------------------- -------------- -------- ------- ----------------------------------------------------
STATUS_ID              NUMBER(20)                      id
STATUS_CODE            VARCHAR2(20)   Y                code used everywhere
SHORT_DESC             VARCHAR2(100)  Y                Short description
EMAIL_SUBJ             VARCHAR2(200)  Y                email subject
EMAIL_BODY             VARCHAR2(2000) Y                email body
EMAIL_REMINDER         VARCHAR2(1)    Y        'N'     If 'Y' then a reminder will be attached to the email
EMAIL_NOTIFY           VARCHAR2(1)    Y        'N'     If 'Y' then email is sent, else no email action
EMAIL_REMINDER_DESC    VARCHAR2(2000) Y                Body of the reminder (text only)
EMAIL_REMINDER_SUMMARY VARCHAR2(200)  Y                summary of the reminder (text only, no newlines)

Any ideas why I am experiencing a hang when selecting from the table? This hang appears in the command window as well.

Raj

 

[Marco Kalter]

I recreated this table, and added/queried some data on a 10g server and client. This worked fine. Perhaps the data is causing problems. Can you perform an export of this table and send it to me?

 

[Raj]

Do you have an email address to which I can send to?

Raj

 

[Raj]

Marco,

I have sent you the table export by email. It is a small file.

Raj

 

[Marco Kalter]

Thanks, I have received it, and will check it out.

 

[Marco Kalter]

This still works just fine for me. This will be difficult to tackle since the access violation occurs deep inside an internal Oracle Net library.