Recent content by MarcusRangel

It worked like a charm, thank you! Some additional information for posterity: the 32-bits version was working fine; same for version 15 64-bits.

Good morning, Starting this morning, all my users are getting this error at logon: "Access Violation at address XXX. Write of Address YYY" (see image). Our version is 13.0.6.1910/1911 (64-bit) running on Windows 10 64-bit, connecting to Oracle 12.1; everything was working on Friday. Any ideas...

So... should I look for the arraysize setting in a future version? :)

EDIT: After logon trigger, not DDL trigger.

Well, that was it, but with a twist. Our developers have that privilege, but there's also for their convenience a DDL trigger that switches their CURRENT_SCHEMA to the owner of the objects.The debug windows is trying to create the temporary table in that schema. We'll just do some workaround...

Here is the debug output: https://s3.amazonaws.com/kiman-public/Debug.zip What I did was: run plsqldev, connect to a database hosted in AWS, open the package (view spec and body), wait ~3 minutes until loaded, close plsqldev. The same package opens in 4 seconds from a database inside my network.

Hello, We have recently upgraded to the latest PL/SQL Developer version and one of the new features is giving us a hard time. As you can see in the screenshots, the attempt to execute SQL in a debug session is crashing because some privilege is missing. The user has "debug any procedure" and...

Well, it's a performance issue. Our development databases are in AWS, so it would be more efficient to bring everything in larger chunks. For instance, using SQL*Plus: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data...

Hello, I'm having the same problem. Have you found a solution? Best regards, Marcus

Thanks a lot, Charlie. This procedure alone did not solve my problem, but I combined it with the latest bios upgrade from Dell and things now seem to be working.

Dear friends, Does anybody know a tool for finding out the impact on Oracle Forms when you change a database object ? For example, if I am changing EMP.ID from number(5) to number(10), which forms do I have to check ? TIA

Dear Friends, Does anybody have the list of grants needed for a user to execute all the queries run by the "Tools > Sessions" option ? TIA, Rangel

Yes, it is true. But the only thing that happens 100% of the tries is the hangup when trying to login on startup. This one is really a hangup, I waited for 3 or 4 hours and nothing happened.

A correction: "In addition to that, sometimes it seems frozen ( **Application not responding**, no CPU and no network activity) but if I wait 10 minutes it finally loads the package."

If I try to log in at the initial screen, it hangs right there. If I skip connection, it opens normally but hangs up mostly when I select a big package and choose the "Edit Spec and Body" option. If I never login, it sometimes hangs when I try to open the 7th or 8th file (sql files containing...