Toad World® Forums

Access violation when executing PLSQL block with large dbms_output

Everytime the following block is executed via “execute as snippet” an access violation occurs several times

begin
for i in 1…100000 loop
dbms_output.put_line(‘Hallo’);
end loop;
end;

Exception:


2.1 Date : Tue, 20 Jan 2015 09:18:23 +0100
2.2 Address : 00000000041A0550
2.3 Module Name: Toad.exe - (Toad™ for Oracle®)
2.5 Type : EAccessViolation
2.6 Message : Access violation at address 00000000041A0550 in module ‘Toad.exe’. Read of address 000000001B04A000.
2.7 ID : 55FA0000
2.8 Count : 1
2.11 Sent : 0

[View:~/cfs-file.ashx/__key/communityserver-discussions-components-files/86/supportbundle.txt:550:0]

I cannot reproduce the AV, but I do see that performance when adding the output compared to earlier versions is horrific. The performance bug is fixed for next beta. For the AV, can you zip and send me your user files folder to michael.staszewskiquest.com?

Thanks,
Michael

On 01/20/2015 03:29 AM, wolkon wrote:

Access violation when executing PLSQL block with large dbms_output

Thread created by wolkon
Everytime the following block is executed via “execute as snippet” an access violation occurs several times

begin
for i in 1…100000 loop
dbms_output.put_line(‘Hallo’);
end loop;
end;

Exception:

Your mail gateway blocked the attachment. Try renaming the .zip to a .txt extension first.

Michael

On 01/20/2015 03:29 AM, wolkon wrote:

Access violation when executing PLSQL block with large dbms_output

Thread created by wolkon
Everytime the following block is executed via “execute as snippet” an access violation occurs several times

begin

for i in 1…100000 loop

dbms_output.put_line(‘Hallo’);

end loop;

end;

Exception:

Hi,

it seems this problem does not reproduce any more in the latest beta. Thanks a lot.

Regards,

Wolfgang