Access violation at address orageneric10.dll

[sdufour]

Receive this error when querying the following table.

SQL> desc table_name
Name Type
-------------- ----
SOURCE_TABLE VARCHAR2(4000)
ATTRIBUTES XMLTYPE

We only receive the error when the rownum reaches > 99.

Access violation at address 03AD01F3 in module

 

[Marco Kalter]

Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[sdufour]

Message sent.

 

[sdufour]

Did you mean a private message here through this system or an email to "support@ allroundautomations.com?"

 

[Marco Kalter]

I meant an e-mail to support.

 

[James B]

sdufour> Did you ever get a resolution to this? The forum has numerous posts about this issue from all the way back in 2004 to the present. It has apparently been present in 9i, 10g, and 11g, and has been present as far back as PL/SQL Developer 6.0. This really needs addressed by the PL/SQL Dev team.

Our issue is an exact duplicate of yours.

Thanks ~
James

 

[sdufour]

This never got resolved by allroundautomations. I did find a workaround though.

Uninstall your Oracle client
Uninstall PL/SQL Developer
Delete all registry keys pointing PL/SQL Developer (our end users are Windows users)
Reinstall Client
Reinstall PL/SQL Developer

Then it just works....

Dev guys are happy now

 

[James B]

I will try that. It makes sense; this issue didn't start happening until I had to uninstall and reinstall the client. Apparently I need to completely uninstall/wipe out PL/SQL Dev when I do that.

Consider that egg on your face, guys